| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: PostgreSQL Active-Active |
| Date: | 2018-02-06 11:10:21 |
| Message-ID: | 8df75146-1529-d3c6-6561-76a180c1b669@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-02-06 11:12:00 | Re: PostgreSQL Active-Active |
| Previous Message | Dhandapani Shanmugam | 2018-02-06 11:01:47 | PostgreSQL Active-Active |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Frost | 2018-02-06 11:12:00 | Re: PostgreSQL Active-Active |
| Previous Message | Laurenz Albe | 2018-02-06 11:09:25 | Re: Function execution is taking more than 2hrs |