| From: | Michael Grimm <trashcan(at)ellael(dot)org> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Cluster of 3 instances in distinct datacenters |
| Date: | 2026-06-14 11:36:42 |
| Message-ID: | 9AB11AAD-B252-4D3F-8A4B-8B8C9522F3D5@ellael.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
I do currently run a postgres cluster spread over two datacenters about 200km apart. One primary, two secondaries and a master for pg_auto_failover (PAF). This cluster has to deal with a data volume of 8 GB and read-write operations with numbers of 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 distant to the primary and other secondary with quorum. Ping between datacenters 200km apart are ~3ms, ping to the datacenter 1600km 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2026-06-14 19:30:00 | Re: Size of /pgdata |
| Previous Message | Ron Johnson | 2026-06-13 12:39:41 | Re: Size of /pgdata |