From: Stephen Frost <sfrost@snowman.net>
To: Andreas Kretschmer <andreas@a-kretschmer.de>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL Active-Active
Date: Tue, 6 Feb 2018 06:16:01 -0500
Message-ID: <20180206111601.GI2416@tamriel.snowman.net> (raw)
In-Reply-To: <8df75146-1529-d3c6-6561-76a180c1b669@a-kretschmer.de>
References: <CAAj4MFGjrtpruHsyw9TjXyWH72B0cfiBDNJpqMLsAUuHc8TGhw@mail.gmail.com>
<8df75146-1529-d3c6-6561-76a180c1b669@a-kretschmer.de>
Greetings,
* Andreas Kretschmer (andreas@a-kretschmer.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
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sfrost@snowman.net, andreas@a-kretschmer.de, pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL Active-Active
In-Reply-To: <20180206111601.GI2416@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox