Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Postgres - Replication - Mailing list pgsql-admin

From Om Prakash Jaiswal
Subject Re: [ADMIN] Postgres - Replication
Date
Msg-id 1636173168.4735929.1490083675424@mail.yahoo.com
Whole thread Raw
In response to Re: [ADMIN] Postgres - Replication  (Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>)
Responses Re: [ADMIN] Postgres - Replication
List pgsql-admin
Tree view
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.

Regards
Om Prakash



On Saturday, 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 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@gmail.com>
To: "jasoninmel" <jasoninmel+1@gmail.com>
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 > 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



pgsql-admin by date:

Previous
From: jasoninmel
Date:
Subject: Re: [ADMIN] Postgres - Replication
Next
From: "Michael@sqlexec.com"
Date:
Subject: Re: [ADMIN] Postgres - Replication