How to use docker to run pgsync?

[tankxxl]

How to pass yml file to docker command?

[zhangcheng]

See if https://github.com/ankane/pgsync/issues/198#issue-1901324389 helps

[magixus]

someone can use docker compose with the following docker-compose.yml

services:
  pgsync:
    image: ankane/pgsync
    container_name: pgsync
    volumes:
      - ./pgsync.yml:/opt/.pgsync.yml
    working_dir: /opt
    command:
      "--schemas public --no-sequences --preserve"

and ./pgsync.yml

from: <connection string source>
to: <connection string target>
to_safe: true # just in case

you can then do:

docker compose run pgsync --debug # or --list or any other additional commands