pgsync
pgsync copied to clipboard
ankane
Sync data from one Postgres database to another
Hi, `--preserve` needs primary key, is there possible adding `--append` to allow append rows directly? Here is my use case: 1. Delete `type='A'` from target table (via psql or jdbc...
Ideas
Ideas - [ ] Add option to wrap the destination sync in a transaction and use delete instead of truncate - #102 - [ ] Add option to delete rows...
When using the overwrite mode, pgsync does a blind upsert which ends up creating duplicate/new row versions for ALL rows involved in the sync regardless of whether or not any...
Here is another idea for you. Sometimes when running a sync the copy operation can be somewhat heavy on the target DB/machine. By adding an option to throttle the copy...
This makes no sense and might actually do something unintended if done by accident, e.g. truncating the source if run with `--truncate`.
Hi, Is it possible to run pgsync with a variable that is a list? e.g. ``` groups: product: products: "where id in {1}" ``` and ``` pgsync product:\(123,456\) ``` This...
I was hoping to allowlist the tables I want sync in `.pgsync.yml`, something like: ```sh tables: - table1 - table2 ``` ## Workarounds - I could do `pgsync table1,table2`, but...
Hi @ankane, --in-batches is only working with numeric primary keys (https://github.com/ankane/pgsync/issues/10). Can this restriction be lifted to make it work with sortable UUIDs? Currently I get following error: ``` operator...
Hello, When I tried using pgsync with docker ```sh docker pull ankane/pgsync alias pgsync="docker run -ti ankane/pgsync"; pgsync --init ``` No file was created. So I think the guide in...
