Postgresql 10 Logical replication MultiMaster

Question

Is it possible use Postgresql 10 logical replication as multimaster? I'm trying install two linux ubuntu server with postgresql 10, but all the sample I have found implement the replication as master to slave and I need to take the replication allowing change the data in the two databases (Publication and Subscriber).

Craig Ringer · Accepted Answer · 2017-07-25 01:59:36Z

3

It's possible, but it probably won't work well. The logical replication in postgres 10 doesn't have conflict resolution features, so it'll fall over quite easily if you write (say) a row with the same primary key to each DB.

It should work well for disjoint sets where no conflicts are possible.

If you need conflict handling you can use BDR for now or another multimaster replication solution.

answered Jul 25, 2017 at 1:59

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql 10 Logical replication MultiMaster

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related