Re: Postgres - Replication

Bacardo asynchronous tool is very good for master master as well as geographical distributed location.
RegardsOm Prakash.

Sent from Yahoo Mail on Android

On Tue, 21 Mar 2017 at 19:16, Poul Kristensen<bcc5226(at)gmail(dot)com> 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(at)sqlexec(dot)com <michael(at)sqlexec(dot)com>:

BDR works fine for writeloads that are geographically separate.  True multi-master is ACID compliant 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(at)yahoo(dot)co(dot)in> wrote:

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 trigger based asynchronous replication system.
RegardsOm Prakash

On Saturday, 18 March 2017 10:24 PM, Alvaro Aguayo Garcia-Rada <aaguayo(at)opensysperu(dot)com> wrote:

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  | RPC: (+51) 954183248
Website: www.ocs.pe

----- Original Message -----
From: "bricklen" <bricklen(at)gmail(dot)com>
To: "jasoninmel" <jasoninmel+1(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)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(at)gmail(dot)com > wrote:

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
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 across BiDirectional Replication (BDR) yet? https://2ndquadrant.com/en/ resources/bdr/

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

--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA