Nikolai Lusan schrieb am 03.10.2019 um 11:05:
I have read the various replication and clustering documentation for postgresql 11, and it looks like what I want is "Synchronous Multimaster Replication". The organisation I am doing this for does not have the money to throw at a commercial solution like BRD, but from my reading it looks like PG v12 may have a method to make such a solution easier to achieve with stock PG.
You might be interested in this blog post: https://info.crunchydata.com/blog/a-guide-to-building-an-active-active-postgresql-cluster