You also have the option of using multi-master replication with Bucardo, but last time we tried to use it with the latest PG versions (10), we ran into several issues, it seems the project hasn't been very active in recent years.
Hi,
If I upgrade Postgres from V9.3 to V10, then need to roll-back to V9.3 after data been entered, is there a way for me to save the new data so that I can re-apply it to the V9.3? After I restore my V9.3 backup, can I simply replay the V10 log unto V9.3? What are my options, if any?
Thanks.
Maria A Rossi
Database Administration
Jackson National Life
email: maria.rossi@jackson.com
cell phone: 517.256.4392
work phone: 517.367.3099
work phone extension: 23099
--