Re: PostgreSQL native multi-master - Mailing list pgsql-general

From Joshua Drake
Subject Re: PostgreSQL native multi-master
Date
Msg-id CAJvJg-Sc5QpoTqjqxwa05+4YkUZn3DWvgL8WOGpkZEMkKtePfw@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL native multi-master  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
In this instance, BDR from 2ndquadrant is probably your best bet. It is commercial but they are a community supporting company.

JD

On Wed, Apr 8, 2020, 08:53 Stephen Frost <sfrost@snowman.net> wrote:
Greetings,

* Vano Beridze (vanuatoo@gmail.com) wrote:
> What are the plans to support multi-master natively?
> What solution would you recommend at this point? preferably free.

You probably want to look at logical replication, which allows you to
replicate data from one PG server to another (with both allowing
writes).  This doesn't have any conflict resolution today, so you have
to make sure there aren't any conflicts or you might end up breaking the
replication.

Having conflict resolution included in core would certainly be nice but
I'm not aware of anyone currently working on it.  I'm sure there are
organizations out there who are committed to open source and who would
be happy to work with you to add that capability to PG though.

Thanks,

Stephen

pgsql-general by date:

Previous
From: Joshua Drake
Date:
Subject: Re: full text
Next
From: Martin Gainty
Date:
Subject: Re: full text