Date: Tue, 6 Feb 2018 06:16:01 -0500
From: Stephen Frost <sfrost@snowman.net>
To: Andreas Kretschmer <andreas@a-kretschmer.de>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: PostgreSQL Active-Active
Message-ID: <20180206111601.GI2416@tamriel.snowman.net>
References: 
 <CAAj4MFGjrtpruHsyw9TjXyWH72B0cfiBDNJpqMLsAUuHc8TGhw@mail.gmail.com>
 <8df75146-1529-d3c6-6561-76a180c1b669@a-kretschmer.de>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="qqiAcBX4pA2EvKS1"
Content-Disposition: inline
In-Reply-To: <8df75146-1529-d3c6-6561-76a180c1b669@a-kretschmer.de>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk


--qqiAcBX4pA2EvKS1
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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

--qqiAcBX4pA2EvKS1
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJaeY5wAAoJEO1sijiDR2RVs18P/A5k3z0umJe2Q3+TLv2wneeX
+wJoRmBHMSgbwgu4QefDvmER/id71boTtkbxkgN/OGfeL+OlU8+RFucBVyhfBEFW
drk1gx/eEXzTRSbG8z1+QPvzM9kPR7XQZQDkiHS/5gqaqZL7w9vA6tGdCFbBUvah
p+UebCNAVkMy5B8cNqposXCxhoE6XCkDjjSjhLbpy8ozLRxgOCRkNInr4CDgQ1/z
OTMhwloMky13GIrd37neaYjVmTeXzq1PNJU5m+L/pl+QzsFyUOTPqrfheqkepKOm
aQEyDVh4ZHQcV9upWjN5to0d6l1trqtMB7LN/6yAAA7g8p6WOMfWOnKwDOa0R0uQ
ZgJM5dKpSduNvGVTdzMgMwUOYd8AL/kuUzd6fx2+Pph+C/GgFSjWZrc/e6xF7Bga
NQodmjPJvbgaNQQJWZxHT1VNBu0khiejnGQWuC9EBx7gkzJNNbF16PFZUKAsIxSd
WH+cO9ZIMmKzAgMQD50AfGt5Y9dkQCoRpe4SzsgAvCSNZInAC7gNAx0+kCSXxuCr
kYCq560/FTYpyTzcexLLFWPRBPRlE1KTijAfvuTCw6zr2b3/DcBmVbcHV/5pp70I
cHrDzm7dSNBhcyVoioenDZQevM1pdb733U1bKoqQXZewg4H6tZDzTVLYv3QcHvSr
O4scePs+NgRQ7aPKd26q
=xpvC
-----END PGP SIGNATURE-----

--qqiAcBX4pA2EvKS1--