Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wYj9F-000SdP-2l for pgsql-admin@arkaria.postgresql.org; Sun, 14 Jun 2026 11:37:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wYj9E-007HPb-28 for pgsql-admin@arkaria.postgresql.org; Sun, 14 Jun 2026 11:37:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wYj9E-007HPF-0q for pgsql-admin@lists.postgresql.org; Sun, 14 Jun 2026 11:37:04 +0000 Received: from mx2.edn2.eu ([65.109.240.115]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wYj9C-00000000Jwz-0ZIw for pgsql-admin@lists.postgresql.org; Sun, 14 Jun 2026 11:37:03 +0000 Received: from smtpclient.apple (p200300fb4f25ad01ac963c4bc7a17bea.dip0.t-ipconnect.de [IPv6:2003:fb:4f25:ad01:ac96:3c4b:c7a1:7bea]) (using TLSv1.2 with cipher ECDHE-ECDSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by mx2.edn2.eu (Postfix) with ESMTPSA id 4gdWS53bDCzHxY for ; Sun, 14 Jun 2026 13:36:53 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ellael.org; s=dkim; t=1781437013; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=B14sohTlFGmAeUaB7TaeSfnCysc/mVnMa7oBmlDFEFs=; b=UaROb7v2Z6LM+o8/5LkTF3bn207sx9UJ3gnZZC11IUMDYtkCIlnvluZcMEY4BBBu6ucw+r jnANZgSlgHHXJHaoxxJeRUzPtN3x/AX0aedSRLk3aYIi9NNgA3th2QGhoL9FY3M5M9xd3L bmp6iHZhnF1oUyXYh3z4c120iRLyV75QwZmztzG1FLKnFz1FpfKhK6rHm+UbZIGfrl+L82 5KFhPPGPAWqqzuREasUwuKHM6+z/kQptergvgKUKRoWg0co8khjNztB3Mn805fvJcE5a3J N2FLjXGq12lgS4O/wNXfq6Zz2MMZ33Cpj3JwySi96DnpRXGUozHuLHQ0oaBx6w== From: Michael Grimm Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\)) Subject: Cluster of 3 instances in distinct datacenters Message-Id: <9AB11AAD-B252-4D3F-8A4B-8B8C9522F3D5@ellael.org> Date: Sun, 14 Jun 2026 13:36:42 +0200 To: pgsql-admin@lists.postgresql.org X-Mailer: Apple Mail (2.3864.600.51.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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