Re: PostgreSQL native multi-master

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(at)snowman(dot)net> wrote:

> Greetings,
>
> * Vano Beridze (vanuatoo(at)gmail(dot)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
>