Re: Advice for geographically dispersed multi master

2019-10-03 Thread Laurenz Albe
On Thu, 2019-10-03 at 19:05 +1000, Nikolai Lusan wrote: > So I am looking to move my current setup of 3 separate, individual, > postgres 11 servers into a multi master cluster. > > I have read the various replication and clustering documentation for > postgresql 11, and it looks like what I want i

Re: Advice for geographically dispersed multi master

2019-10-03 Thread Thomas Kellerer
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

Advice for geographically dispersed multi master

2019-10-03 Thread Nikolai Lusan
-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Hi, /* Disclaimer: I am primarily a systems administrator with some database and DBA history. Although these days I would normally leave this kind of thing to a seasoned DBA this is for my personal use, and the use of a non- profit or