Re: PostgreSQL native multi-master

From: Stephen Frost <sfrost(at)snowman(dot)net>
To: Vano Beridze <vanuatoo(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL native multi-master
Date: 2020-04-08 15:53:39
Message-ID: 20200408155339.GF13712@tamriel.snowman.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Frost 2020-04-08 15:54:34 Re: Using of --data-checksums
Previous Message melvin6925 2020-04-08 15:53:38 Re: Best method to display table information in predefined formats