Ideas

[ankane]

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 of truncate - Data deleted #102
• Add option to delete rows in SQL clause - With Truncate, just delete rows in where clause instead of all existing rows #110
• Change preferred variable syntax ($1) and quote by default
• Add support for variables with commas - variables with multiple values #206
• Only defer necessary constraints - --defer-constraints defers constraints on all schemas, not just the ones being synced #209
• Better error message when primary keys don't match
• Skip columns with incompatible types (currently warns when different)
• Add option to open transaction on source when manually specifying order of tables (for consistent snapshot)
• Retry on connection errors
• Support syncing to different table name. Ideally use Git remote syntax (pgsync src:dst), which is current used for variables. Could change variables to use pgsync product=123.
• Add to_safe_hosts to replace to_safe (with * for all)