Greetings, * Andreas Kretschmer (andreas@xxxxxxxxxxxxxxx) wrote: > Am 06.02.2018 um 12:01 schrieb Dhandapani Shanmugam: > >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. > > 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. BDR and logical replication are options but that's independent of the "zero" RTO/RPO goal. If you're looking for write-scaling, that's a different question (note that to actually get real write-scaling, even with Oracle RAC, you have to be prepared to make app-level changes..). > For HA you should consider normal streaming replication and our repmgr, for > instance. And for Backup (RTO, RPO) our Barman. There's a number of different options both for managing streaming replication and for backup. As mentioned, Patroni is quite good for HA requirements and for for backup, I'd suggest also considering pgbackrest: http://pgbackrest.org Thanks! Stephen
Attachment:
signature.asc
Description: PGP signature
