Re:Bidirectional Replication is coming to PostgreSQL 9.6
by nine_k on Sunday September 25, 2016 @11:06PM
(#12578953)
I can imagine a reasonable use case.
If every node only accepts writes to a particular set of tables (or partitions), and serves as a read slave wrt the rest, the database may remain consistent and more available than a single-master setup. Imagine one node per a geographical region, with each node having a (read-only) picture of the whole.
This is a relatively limited use case.