Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ej1AX-0007UF-6S for pgsql-admin@arkaria.postgresql.org; Tue, 06 Feb 2018 11:12:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ej1AW-0003xy-BJ for pgsql-admin@arkaria.postgresql.org; Tue, 06 Feb 2018 11:12:08 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ej1AW-0003xk-0n; Tue, 06 Feb 2018 11:12:08 +0000 Received: from tamriel.snowman.net ([96.255.250.162]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1ej1AP-0000eF-7U; Tue, 06 Feb 2018 11:12:06 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 3E1265F79C; Tue, 6 Feb 2018 06:12:00 -0500 (EST) Date: Tue, 6 Feb 2018 06:12:00 -0500 From: Stephen Frost To: Dhandapani Shanmugam Cc: pgsql-admin , pgsql-general@postgresql.org Subject: Re: PostgreSQL Active-Active Message-ID: <20180206111200.GH2416@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="Ii/lGvQ8I1XWmP6q" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Ii/lGvQ8I1XWmP6q Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Greetings, * Dhandapani Shanmugam (postgresql95@gmail.com) wrote: > 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. What you're probably looking for is a 3 (or more) node setup with patroni, etcd, and synchronous replication. Note that this will be a shared-nothing architecture, avoiding the risk that something bad happens with the storage system but requiring that the data be replicated multiple times. Using synchronous replication means that you have to have the nodes all close to each other, of course, but meets the zero RPO. Zero RTO is just silly, but with patroni and haproxy you can detect and failover pretty darn fast. Thanks! Stephen --Ii/lGvQ8I1XWmP6q Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJaeY2AAAoJEO1sijiDR2RVhUYP/2TTDkdIDzTvmHriaPirXyaU bw9fCKj/BzseLX/QiWJhahKlgl5itut5f9IOvxTVaCijSIBo6Mddq6KUns+XC1hU sj5zjMultvHNKdY5CSTO1kC34rb9IwHn1NzjdSCXFQKLGSJvdTPMz2j46bM/gkSh alL4NJlAZFPghmD5cYOv8vEegKD4A6wqPfuwwtpMd2WBytaUW9xTFU/sM96kSKR2 HHitWt/f0XZvcKadbSzLu3yeKyIlZqfh3udd/S2jAe9T46lRgK026Lbzqecu0P+r xcNTuKCdnbHqZ5wIgCtRaDrb76DYNiT0TGBIij9qcLJSi7Whef8T9UHdoAJTQW3c 4TpSc5mQES7Z5YwsDLuwbcgoF4Mc6KsGe68qx8C2rvilnXrN0TRimXF7FMuetngF n3sJF0voANGVUerFnbsZ/uD6yGbZml6bggFkilJDMeCwWw9HL+rwgSeluMMZ9BK8 vn3ppIX12kkX8+mFLkashQN3Jx+i6J6gwZTENcHOkYUyYK1Tq3rg8HyiczBi+6uy 5PgmI3SjDLeDvNPQbgr13/YjLqDgEnGsnL0X1m5LuG1hgNjtv8khSaMjxcFTdPon 1hN2CXmRi00KS9hP/YeYyNyJH2EVqh1Vhs/MSZzQEbNghKidHfH2zhBfYCoS+8Dn ZQBDGCrwM5Tf2Ivcnnvz =keRL -----END PGP SIGNATURE----- --Ii/lGvQ8I1XWmP6q--