pgsync

pgsync copied to clipboard

Currently we can exclude one entire table using ``` exclude: - table_name ``` It would be nice to preserve some rows in the table. For example, I have a `settings`...

Hritik14

### Notes I had difficulty camouflaging data based on another column, I think this example makes it clear how this can be done

vmotta8

Hi, We want to use `faker` extension to use for having fake data (localized) we are using `statement` for our column in `pgsync` configuration to run faker functions (faker is...

mhkarimi1383

[Feature] schema-only should confirm before existing table is dropped!

1

The flag `--schema-only` is misleading, if it drops the table there needs to be user confirmation! Although the documentation states so, it would be easy to miss. Please enforce and...

sunapi386

Option to define target DB schema

3

Hello , Thanks for bringing up this exciting data migration tool. Just want to check is there any possibility to define the target schema as well. Since my case schema...

PGPAWAN

How to use docker to run pgsync?

1

How to pass yml file to docker command?

tankxxl

Sync aborting due to server version mismatch

2

Hi, Any idea how can this issue be solved? Thanks I'm using postgres:17.6-alpine and ankane/pgsync:latest docker images. ``` From: source_db on source-postgres:5432 To: target_db on target-postgres:5432 pg_dump: error: aborting because...

phspires

Truncates the source if from and to uses same database

1

So, it truncated the tables from source db for me. Sorry no time, need to fix it now. Just reporting the issue.

akvyalkov

Please create a new issue to discuss any ideas or share your own. - [ ] Add option to wrap the destination sync in a transaction and use delete instead...

ankane

pgsync groupble:123:2025-04-06:2025-04-08

marcpmichel