Re: Postgres - Replication

From: Alvaro Aguayo Garcia-Rada <aaguayo(at)opensysperu(dot)com>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, jasoninmel <jasoninmel+1(at)gmail(dot)com>
Subject: Re: Postgres - Replication
Date: 2017-03-18 16:54:35
Message-ID: 30946781.200.1489855972019.JavaMail.Administrator@natalia-srv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2017-03-20 12:55:13 Re: QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions
Previous Message bricklen 2017-03-18 16:41:48 Re: Postgres - Replication