Ideas

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 - #102
• Add option to delete rows in SQL clause - #110
• Change preferred variable syntax ($1) and quote by default
• Add support for variables with commas - #206
• Only defer necessary constraints - #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)

This issue is a broad list of possible ideas rather than a scoped task, and it names no files, tests, or entry points. Start by reviewing the linked issues such as #102, #110, #206, and #209, then create a separate issue for one selected idea with a defined scope and acceptance criteria.