Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dVD4P-0008Ng-9y for pgsql-admin@arkaria.postgresql.org; Wed, 12 Jul 2017 08:32:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dVD4O-0000uw-O5 for pgsql-admin@arkaria.postgresql.org; Wed, 12 Jul 2017 08:32:28 +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 1dVD2Z-00067Y-9q for pgsql-admin@postgresql.org; Wed, 12 Jul 2017 08:30:35 +0000 Received: from sonic310-46.consmr.mail.sg3.yahoo.com ([106.10.244.166]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dVD2U-0000dA-Nb for pgsql-admin@postgresql.org; Wed, 12 Jul 2017 08:30:34 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1499848222; bh=Bfy0wol3SjcpGYQJG0fDNWcjQbjm4WSQlprHNP4gHnU=; h=Date:From:Reply-To:To:Cc:Subject:References:From:Subject; b=exPTtFs5+A9945qZs2FSaDYbAcfJQB445Kpx3Y+j7Obb0s2p/2Y2DT9PNRkm9PQcLXHtUsOp6lRxRyAtco03dv+veJ7bcTf04ZErO7YKfBolLwltJMbKCeCSgDKpuiuN8g/Ibth+8Oa9Jn3nxmU6t7aEZtSVKFD7vkL5Y/o2+Z5yy37O09dtupuaSCyu7GYt7EXGOet0V6VjeiIKtnglgeIj68XymoU61A3gc6m+QfLrgiMN4G4KWBb/Gxm2g+WwyiVErfDEO5c7xGgqh2Jd8LiuVOGjzKP8iWQf0RZUssYuzVAJxXo0d94GWvssPp7j5MwX/+f0fxo6JIX/f1NDxA== X-YMail-OSG: zozEQRcVM1kZdOKDuUTbjV1l6T_MGVaxkclTr_oxL4bjASpc4_j2WPkf5gyHK0J x_iYHLxHphPaaLnCYy7f5e7yr9sEgqb6s1nfFZ_3LF_ysrq3jz0NSqZq4c2CV5voz9o0yb4m35xO Epwdaom.gBwvc_66Tm7jaeAFEiKAOcUxwiLiZWceIb1zuWls6NvdEPLFZMpvCWhepGGZsFxfaA32 flrDd14oS9z.QumSCUSI61YVbCcqJm1gfh4fM1COo6SGrdn.pXbZWouLFxd8mBEH2syILQyetr4I ywaZ.09KtWXazIT37rmazE35juseBm2lGuDGpBvigjn7.GoGBRdDOuxVz.oBjGXPhcv_VPx609Di lz65jSNR7Ia6aYnMzAUD.JjTbZZY0R_Y1aUK8RrbcdaJP1p8ZZkZnhQl8WSqvQaXurmPVKmfZvPA DBwZKy4BJHaHXqUCoO_WN7u0k7FYSPTZzrytPGACIJqjL1EbUhuQtYvT8AR0QOGTK52iRlr.iXmA bjuWHta2rLtoGzdJMqZ.C_MdJgvrI8SnX7Sl7kH0oFA-- Received: from sonic.gate.mail.ne1.yahoo.com by sonic310.consmr.mail.sg3.yahoo.com with HTTP; Wed, 12 Jul 2017 08:30:22 +0000 Date: Wed, 12 Jul 2017 08:26:21 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: "op12om@yahoo.co.in" To: "bcc5226@gmail.com" Cc: Pgsql-admin Message-ID: <1451677064.4285950.1499847981519@mail.yahoo.com> Subject: Re: Postgres - Replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4285949_1704047755.1499847981515" References: <1451677064.4285950.1499847981519.ref@mail.yahoo.com> X-Mailer: WebService/1.1.10014 YahooMailAndroidMobile YMobile/1.0 (com.yahoo.mobile.client.android.mail/5.16.2; Android/6.0.1; MMB29M; land; Xiaomi; Redmi 3S; 4.97; 1280x720;) Content-Length: 11327 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_4285949_1704047755.1499847981515 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Bacardo asynchronous tool is very good for master master as well as geograp= hical distributed location. RegardsOm Prakash. Sent from Yahoo Mail on Android=20 =20 On Tue, 21 Mar 2017 at 19:16, Poul Kristensen wrote: = If you redirect you syslog to another server, the "pg_log" will be written= in/var/log/... and pg_log will just write that it has been redirected. /Poul 2017-03-21 12:07 GMT+01:00 Michael@sqlexec.com : BDR works fine for writeloads that are geographically separate.=C2=A0 True = multi-master is ACID compliant when you have a global transaction manager l= ike Postgres-xc or Postgres-xl. Regards Sent from my iPad On Mar 21, 2017, at 4:07 AM, Om Prakash Jaiswal wrote: 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 --=20 Med venlig hilsen / Best regards Poul Kristensen Linux-OS/Virtualizationexpert and Oracle DBA =20 ------=_Part_4285949_1704047755.1499847981515 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Bacardo asynchronous tool is very good for master master as well as geograp= hical distributed location.

Regards=
Om Prakash.
<= br>
On Tue, 21 Mar 2017 at 19:16, Pou= l Kristensen
<bcc5226@gmail.com> wrote:
If you redire= ct you syslog to another server, the "pg_log" will be written in
/var/l= og/... and pg_log will just write that it has been redirected.
/Poul

<= br clear=3D"none">

2017-03-21 12:07 GMT+= 01:00 Michael@sqlexec.= com <michael@sqlexec.com>:
BDR works fine for writeload= s that are geographically separate.  True multi-master is ACID complia= nt when you have a global transaction manager like Postgres-xc or Postgres-= xl.
=
Regards


Sent from my iPad=

On Mar 21= , 2017, at 4:07 AM, Om Prakash Jaiswal <op12om@yahoo.co.in> wrote:

I am using B= ucardo.
It is working fine. It has been runinnin= g for 5 years across 50 replicated nodes.
I stro= ngly recommend Bucardo for master-master replication.
It is trigger based asynchronous replication system.

Regards
Om Prakash

=


On S= aturday, 18 March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com> wrote:


I have some experience with BDR. Works fine.

Alvaro Aguayo
Jefe de Operacion= es
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" <bricklen@gmail.com>
To: "jasoninmel" &l= t;jasoninmel+1@gmail.com>
Cc: pgsql-admin@postgresql.org
Sent: Saturday, 1= 8 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 > wrote:



Please note that I'm open for any other replic= ation method that would allow
better scalability. One of= the best option would be to have Multi-master
setup tho= ugh 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 across BiDirectional Replic= ation (BDR) yet? https://2ndquadrant.com/en/ = resources/bdr/



--
Sent via pgsql-admin mailing list (pgsql-admin@postgre= sql.org)
To make changes to your subscription:
http://www.postgresql.org/ ma= ilpref/pgsql-admin



=



-= -
Med venlig= hilsen / Best regards
Poul Kristensen
= Linux-OS/Virtualizationexpert and Oracle DBA
------=_Part_4285949_1704047755.1499847981515--