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 - #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)