ankane/pgsync目前只支持单向同步,但可以结合使用pgdiff和pgsync实现双向同步。以下是示例代码:
gem install pgdiff
gem install pgsync
pgdiff postgres://user1:pass1@host1/source_db
postgres://user1:pass1@host2/dest_db > diff.sql
pgsync --schema public --preserve-ids postgres://user1:pass1@host1/source_db
postgres://user2:pass2@host2/dest_db diff.sql
pgdiff postgres://user1:pass1@host2/dest_db
postgres://user1:pass1@host1/source_db > reverse_diff.sql
pgsync --schema public --preserve-ids postgres://user1:pass1@host2/dest_db
postgres://user1:pass1@host1/source_db reverse_diff.sql