ankane/pgsync

Incremental update and foreign keys

Akshaypatil619 opened this issue · 1 comments

Hi @ankane ,

In issue 144 you mentioned to use another tool for incremental update or sync do you any gem or git repo this will help us. also for foreign key which method is reliable defer constraint or sync data one by one tables?

Hi @Akshaypatil619, there are tools for trigger-based replication like Bucardo, and probably ones for logical replication as well. For foreign keys, both methods should be reliable.