Cluster of 3 instances in distinct datacenters - Mailing list pgsql-admin

From Michael Grimm
Subject Cluster of 3 instances in distinct datacenters
Date
Msg-id 9AB11AAD-B252-4D3F-8A4B-8B8C9522F3D5@ellael.org
Whole thread
List pgsql-admin
Hi,

I do currently run a postgres cluster spread over two datacenters about 200km apart. One primary, two secondaries and a
masterfor pg_auto_failover (PAF). This cluster has to deal with a data volume of 8 GB and read-write operations with
numbersof the very low end. 

This setup runs perfectly well for the last month.

Now, I intend to move the server -running the PAF master and a secondary without quorum- to a datacenter about 1600km
distantto the primary and other secondary with quorum. Ping between datacenters 200km apart are ~3ms, ping to the
datacenter1600km apart is ~24ms 

Given the low traffic this cluster has to deal with: can a PAF master running at such a distant datacenter control the
cluster?

Thanks and regards,
Michael




pgsql-admin by date:

Previous
From: Raj
Date:
Subject: Re: Size of /pgdata
Next
From: Laurenz Albe
Date:
Subject: Re: Size of /pgdata