Cluster of 3 instances in distinct datacenters

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

Browse pgsql-admin by date

  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