From: Scott Ribe <scott_ribe@elevated-dev.com>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.500.171.1.1\))
Subject: Re: HA Setup Review
Date: Tue, 30 Apr 2024 10:38:34 -0600
References: 
 <CAHecRenM5M9G3mmbE5srhUso0MFC-g6F5rVjwrXo_vZ7fvEt9Q@mail.gmail.com>
 <CANzqJaBd1yhJxCr25iiTwnOstVo_TcZU5AHdv=s+zTEeOgjO=w@mail.gmail.com>
 <PH0PR19MB5573B83EE17D1393CF88B6E5D61A2@PH0PR19MB5573.namprd19.prod.outlook.com>
 <CANzqJaBz8Of8DANUehyRC1KEniGUikp1KPk29DNhh66Vuhan5Q@mail.gmail.com>
 <CAHecRem5iCXo7LwhY8RqxKyH-TQa4Jyr8bVUUgiiSfb4uL=tuA@mail.gmail.com>
To: akshay polji <akshay.polji@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CAHecRem5iCXo7LwhY8RqxKyH-TQa4Jyr8bVUUgiiSfb4uL=tuA@mail.gmail.com>
Message-Id: <C0889997-8DA2-479B-82D0-C8945A35FF7E@elevated-dev.com>
Archived-At: 
 <https://www.postgresql.org/message-id/C0889997-8DA2-479B-82D0-C8945A35FF7E%40elevated-dev.com>
Precedence: bulk

> On Apr 30, 2024, at 10:29=E2=80=AFAM, akshay polji =
<akshay.polji@gmail.com> wrote:
>=20
> So do you think that even such a cluster with 3 node pgpool + =
postgresql (running on the same machine)  Synchronous Replication (Any =
one out of the two replicas) would mean Primary DB will be at risk of =
degraded performance?=20

All cloud providers have downtime and outages. Maybe this is reliable =
enough for you, but just don't treat it as a guarantee. The point is: if =
a network glitch, or failure of a replica, can cascade to cause failure =
of primary, is that really HA?