Hacker News Reader

PG 9.6 brought bidirectional replication in and supported via mainline extension (no patches).

http://blog.2ndquadrant.com/bdr-is-coming-to-postgresql-9-6/

Okay, sorry, you're right. In my head "multi-master" is N > 2, for some reason. Probably because of Bucardo.

Also, we're only on 9.5, so I haven't gotten to play with BDR yet, though I do have a meeting next week to start talking about how we might use logical decoding.

I may be missing something, but I don't see any mention of 2 nodes in that blog post. In fact, BDR is designed to be run with many more nodes. That being said, it's an asynchronous multi-master, suitable for geo-distributed architectures. Everyone has their own concept of what multi-master is, sadly.

The other thing is that "PG 9.6 brought ..." might suggest this is built into PostgreSQL 9.6. That's not quite the case - we're working on moving it into core, but that takes time. For now it's an extension (plug-in). PG 10 will however include pglogical, which is another step in that direction.

Reply on news.ycombinator.com