From: | Stephen Frost <sfrost(at)snowman(dot)net> |
---|---|
To: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL Active-Active |
Date: | 2018-02-06 11:16:01 |
Message-ID: | 20180206111601.GI2416@tamriel.snowman.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Greetings,
* Andreas Kretschmer (andreas(at)a-kretschmer(dot)de) 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
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel Teixeira Santos | 2018-02-06 11:18:18 | Re: Postgres install |
Previous Message | Stephen Frost | 2018-02-06 11:12:00 | Re: PostgreSQL Active-Active |
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel Teixeira Santos | 2018-02-06 11:18:18 | Re: Postgres install |
Previous Message | Stephen Frost | 2018-02-06 11:12:00 | Re: PostgreSQL Active-Active |