Am 06.02.2018 um 12:01 schrieb Dhandapani Shanmugam:
Hi Gurus,
Do we have active-active setup in postgreSQL, like we have in oracle
RAC?. Sorry if this question has been addressed already. What will be
best open source HA for postgresql with zero RTO and RPO.
-D
we have BDR, but this isn't the same as Oracle RAC. BDR is more for
replication over long distances (around the globe), and BDR isn't a
solution for HA.
For HA you should consider normal streaming replication and our repmgr,
for instance. And for Backup (RTO, RPO) our Barman.
http://www.pgbarman.org/
https://blog.2ndquadrant.com/news-and-roadmap-for-bdr-multi-master-postgresql/
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
