Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cqEso-0003bk-S1 for pgsql-admin@arkaria.postgresql.org; Tue, 21 Mar 2017 08:11:11 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cqEso-0005TB-Cq for pgsql-admin@arkaria.postgresql.org; Tue, 21 Mar 2017 08:11:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cqEsn-0005Sa-Dq for pgsql-admin@postgresql.org; Tue, 21 Mar 2017 08:11:09 +0000 Received: from nm35-vm10.bullet.mail.gq1.yahoo.com ([98.136.216.155]) by magus.postgresql.org with esmtps (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cqEse-0003wO-MN for pgsql-admin@postgresql.org; Tue, 21 Mar 2017 08:11:08 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1490083856; bh=2MwG6nFpY+kGXMIflwyhU6fzMXvtFty4Z9fRxZbpIz8=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=ZAM9D+B1eV4aKdpngVw6hx33QCqFZQX2MLxuWyyInwB9Xi/umv50BJtiBmEoX79iXL/VlQKaJYN9B3DQTNpetUNg4H9peCa8NrMgDGB52ecOFD5oSnpgDkTlDlT71Sxa6COqWALCIT3Edd+CueFHHvBbTZcbuqD0c7um2nUv/X0MIl4CiOGA1n26sXR94X2WtHuNzc96aqfe5xRMC+A/PjKkFsc3MaaUeR33vF/A0gyfOgQQy9WTSlrTxPArpBxWEp7Own891FKncZBwiUifZMA9RdjdAcTZlJZpJ+LJK0gD+F1A6EeE5hM7urOL8HAceHTdFkloUliu2Oe83IatGw== Received: from [127.0.0.1] by nm35.bullet.mail.gq1.yahoo.com with NNFMP; 21 Mar 2017 08:10:56 -0000 Received: from [98.137.12.191] by nm35.bullet.mail.gq1.yahoo.com with NNFMP; 21 Mar 2017 08:07:56 -0000 Received: from [106.10.166.123] by tm12.bullet.mail.gq1.yahoo.com with NNFMP; 21 Mar 2017 08:07:56 -0000 Received: from [106.10.150.25] by tm12.bullet.mail.sg3.yahoo.com with NNFMP; 21 Mar 2017 08:07:56 -0000 Received: from [127.0.0.1] by omp1026.mail.sg3.yahoo.com with NNFMP; 21 Mar 2017 08:07:56 -0000 X-Yahoo-Newman-Property: ymail-4 X-Yahoo-Newman-Id: 213414.37380.bm@omp1026.mail.sg3.yahoo.com X-YMail-OSG: BITly2AVM1na5X4Ksi2D4WSzfceBB71a8ulO1hDhOKTWaJeWWcQOjuN1S4uVPld SKd6gGrFXpWGJhu18xVMnYTal60N2fE2Xh6r1xYvxELaDNRNeO9M1VCELbfeSI17GQSSb9k3Sra6 YM7Mti7uZ17br57B6lh9IHFqNpOnwKTYmtxiPKsFqMcYJtMCS8FjGdrqrGWqGVzD7MC_2YPRLMRd VAOaX_59gox3EanEJTtQh4XPgmXk1t.68sA7edBbZkVyVUh2oryQaGaLvdSEqVGd17WZLU_sc0xY Kr1Gn1kqiNi7pX0ULa_4M6y_btj_J_rBJoELyr_G4gSYXyuOPh8_tMWpHmrHvBLYmZmxi_tsifJe 6UDTwoh53Pd65a3hMFoiAsTHHWymuMbEwbzwexNVX32l6YRDj3BbSE2wapJlodPkmVazJGrtTWtu li87mk5E_bHEhcrTWirovg4uYIz1C7xpyQLIeqPKJFRLKnamucpjtAho5_FYzuRj2hqiCnEcuK7K aK12Ug2YWXr3EuRRL6Mf7WrJxtoBR4ygoTjw- Received: from jws600051.mail.sg3.yahoo.com by sendmailws107.mail.sg3.yahoo.com; Tue, 21 Mar 2017 08:07:55 +0000; 1490083675.828 Date: Tue, 21 Mar 2017 08:07:55 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: Om Prakash Jaiswal To: Alvaro Aguayo Garcia-Rada , bricklen Cc: "pgsql-admin@postgresql.org" , jasoninmel Message-ID: <1636173168.4735929.1490083675424@mail.yahoo.com> In-Reply-To: <30946781.200.1489855972019.JavaMail.Administrator@natalia-srv> References: <1489553982608-5949678.post@n3.nabble.com> <1398211489576882@web5g.yandex.ru> <1489721413358-5950172.post@n3.nabble.com> <1489721642262-5950175.post@n3.nabble.com> <30946781.200.1489855972019.JavaMail.Administrator@natalia-srv> Subject: Re: Postgres - Replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4735928_1994788408.1490083675421" Content-Length: 6168 X-Pg-Spam-Score: -4.8 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_4735928_1994788408.1490083675421 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I am using Bucardo.It is working fine. It has been runinning for 5 years ac= ross 50 replicated nodes.I strongly recommend Bucardo for master-master rep= lication.It is trigger based asynchronous replication system. RegardsOm Prakash =20 On Saturday, 18 March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada wrote: =20 I have some experience with BDR. Works fine. Alvaro Aguayo Jefe de Operaciones Open Comb Systems E.I.R.L. Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103=C2=A0 | RPC: (+51= ) 954183248 Website: www.ocs.pe ----- Original Message ----- From: "bricklen" To: "jasoninmel" Cc: pgsql-admin@postgresql.org Sent: Saturday, 18 March, 2017 11:41:48 AM Subject: Re: [ADMIN] Postgres - Replication On Thu, Mar 16, 2017 at 8:34 PM, jasoninmel < jasoninmel+1@gmail.com > wrot= e:=20 Please note that I'm open for any other replication method that would allow= =20 better scalability. One of the best option would be to have Multi-master=20 setup though I haven't seen any documentation around the support for such= =20 capability by Postgres.=20 Postgresql doesn't support multi-master in the core project but there are o= ptions available. Have you come across BiDirectional Replication (BDR) yet?= https://2ndquadrant.com/en/resources/bdr/=20 --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin =20 ------=_Part_4735928_1994788408.1490083675421 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I am using Bucardo.
It is working fine. It has been runinning for 5 years across = 50 replicated nodes.
I strongly recommend Bucardo for master-master replication.
It is trig= ger based asynchronous replication system.

Regards
Om Prakash


On Saturday, 18 = March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com&= gt; wrote:


I have some experience with BDR. Works fine.
<= br clear=3D"none">Alvaro Aguayo
Jefe de Operaciones
Open Comb Systems E.I.R.L.

Oficina: (+51-1) 3377813 | RPM: #034252 / (+51) 995540103  | RPC: (+= 51) 954183248
Website: www.ocs.pe

----- Original= Message -----
From: "bricklen" <brick= len@gmail.com>
To: "jasoninmel" <jasoninmel+1= @gmail.com>
Cc: pg= sql-admin@postgresql.org
Sent: Saturday, 18 March, 20= 17 11:41:48 AM
Subject: Re: [ADMIN] Postgres - Replicatio= n





On Thu, Mar 16, 2017 at 8:34 PM, ja= soninmel < jasoninmel+1@gmail.com > wrote:
<= br clear=3D"none">

Please note that I'= m open for any other replication method that would allow
better scalability. One of the best option would be to have Multi-master <= br clear=3D"none">setup though I haven't seen any documentation around the = support for such
capability by Postgres.


Postgresql doesn't support multi-= master in the core project but there are options available. Have you come a= cross BiDirectional Replication (BDR) yet? https://2ndquadrant.= com/en/resources/bdr/



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



------=_Part_4735928_1994788408.1490083675421--