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 1vJCw9-00EXgw-1A for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 15:39:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJCw6-00CUhh-0e for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 15:39:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJCw5-00CUhY-2X for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 15:39:05 +0000 Received: from mout.perfora.net ([74.208.4.194]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vJCw3-007MmI-1d for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 15:39:05 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sqlexec.com; s=s1-ionos; t=1762961941; x=1763566741; i=michaeldba@sqlexec.com; bh=2ENAGDIZ09YGJBad9FdKtlLEYogA56wgfb4G8APBcVE=; h=X-UI-Sender-Class:Content-Type:Content-Transfer-Encoding:From: Mime-Version:Subject:Date:Message-Id:References:Cc:In-Reply-To:To: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=PBaRPHWSQWXjO+rqi6krOCRjSBTn5kjeGnl1o2Y94TAyCBMtAiEib7NODOsHExp+ vdGgOGBlvTMTl1QWmadIkvYrViZMqvD0KOAoWJGzVy03+ggfrRiVsVgZ3tytE0YsH 1tAPXI4y6JBB16ArhULEofX9l8XY/5G3RmaPbRx8kz128mZ9qEbeMeCpxXMNAXshd mEHB99OPWZTZXszBxe/ph+XiKQJYoiDYeirGUf07ywTas23al/CUx2eeB5IZTPEOc DmMi0LYMn8wDHOSLjYcrd/dB6+x2ulesh+4ntHg4RHreqmCOcIz4GwGeDhtlU0/cO yvVR7d8G9hTnJfTYJA== X-UI-Sender-Class: 55c96926-9e95-11ee-ae09-1f7a4046a0f6 Received: from smtpclient.apple ([172.59.115.139]) by mrelay.perfora.net (mreueus003 [74.208.5.2]) with ESMTPSA (Nemesis) id 0Lij1v-1vtdkW2QDF-00fRYM; Wed, 12 Nov 2025 16:39:01 +0100 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: "MichaelDBA@sqlexec.com" Mime-Version: 1.0 (1.0) Subject: Re: Postgres HA Deployment Questions Date: Wed, 12 Nov 2025 10:38:50 -0500 Message-Id: <8C10A31A-EB78-48B9-B44E-5214E6D2D97D@sqlexec.com> References: Cc: pgsql-admin@lists.postgresql.org In-Reply-To: To: Joseph Craig X-Mailer: iPhone Mail (22G100) X-Provags-ID: V03:K1:cmQniJat6y34Ix+x7xabgd1LXhmZ/8mYwZdZf16w9v+ttVwLQRo aJ7Iax6SCHYEYbsSwmu5ylxODEu4PxY+NYfS86TBQLiPG60E4QnUG5sXzP5kgVFVze5P6QZ eTPiunhHhzehzAvzLJxx2fHJm1QzScj3ibrtozgpiaGludcryWHaKLE/K0hNjeaajfFsCNn bHkzyppTIDSdmvIu16qxQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:v8i0McGyDs4=;30EK6pi3MUMPhdh5n3ePh6sWI9l NdqcmY78BAi+dqiU3djWlBTkYoV6kU9sNfx7YP1UM3khw6635VZpjI+UDGss09Bp0HScAj0l0 jmF1EejuAzXjjn2m89toJVDmwiYT/c+cZAYa5XgBxlnXa4TFo8FJ2P3lwp0bJPD1aDpl9kr/0 2/ICfnt2MK+NBhxxpfKq4MpN03XU3KjIHN1s1OI6enYViC28AlxmhFAWPxUfAU3wnEoin4tnO j8UFOXNzw6Var3FzXgNcLTaJvKhHZYZNe9K93CqEv9X8KF9LIDW8CPlK54tEhj1wiZhwsEhJh RHjkJ+7kg9nXWNc4bW76+genOeMxaE1kMFXkzHLa+aMYoeNs75mp6lTU81Mye/H9CHGlu/aSE OqZMGJumGgqBMOoa9P6zlHI8rd4oia27kSONa4o0VM2ABJGU/p0pS03VCxM/oAMbZ0BilWEp6 nd02lRqjjtrYcbr7NgQs1utBbHGcpuWWOtD4HCyikkLP5zbAoHTfLOE5OMAHwjyhTyohWdaYf 57GsynE/JawgTsMnbU6uyExdDmEexrFiRINKxiwmrUsJ/a3vFMZ3T4Yeq3awabAn5y3I3Ipog YeKn2Ws9jWMFYz2MJ5x3YrIf0g0KUZkt8QdX2NGlFRmGs8E1NEEELneunAW3bpJz6Ysm48Aa2 K7VXor8cdiQ1wS7NE0qUdb16+JCmX2YyeeHmXAT+fDG47SSVpnttjfJXWqfSez3t6FaCpx3Ol Pt8CgQGraRLK2dXc8B04L7dI0nUcJErQL/Zn1U84KTI7gWi9JN2tJ8FYepk04TDsgJpjRqvIA DN1TmJenLv80GKIACNqZ/O4tIZRRGIQh6Z7QgORkvegad7rrjIXbodyvRPS7ibUZccSoR7VbG dBchTIsjA7k04QzSYtU/Fxq/6n4AeTIFABBBixcg2n3mBX4Ybmwm0US6bYrq8aHprhIcoKqc1 htDxRBqJX5LrfFcDWd5PRUdrI7fTuGVOi0G+uHH7FTWaHBFJ0mobInBi58UkbEBbcj0u1Yhtc Nb9IUJCjx9MziSxNrtqoBHMoyRjlrd7bhWnwNhe8HknfCOdY2GsWvQIiOBuk8w+EyjjaeQcGE GHYxcNIZK8Hkt6InmCUClbonQPEVUd3Bk6qgSAYUCekoqfzm1FT4g4yP2ksbwveKR/T27POu0 CE+FjLx/SIDKjskTmPMXjJedvkWNK6paN6A3bgNyHs1LhztfRKco6amlpOS4KkDGlUYc7awj1 DDpPqDWEyPjeYtBBkQ5l1sYQKy5YtumQioVSrwkocokk+Nax00DQ5S5YtYkDwtBcr/5YqQUho zIHum/58t+79bWz63vRV8BhStfIcHQ+8JYOvL1Js5/xtap75nFFsmRYFc1JOUfWtB+EwkAUmq Jo/QQDugMqXD5N90vbYEkvNYwE3WYyMYA4gnj5fIHfAEbpd0P3j4FRo9a2QGK/ljh6sdVVJsx U3SkAA4WK1y4Bd1dt1l89s6GXOV/jvCzg9JK4r1QCu3EuVwc7cF6n9P5dn8GfoApFfLvhOjF9 PUYa7qS6zmYxc116Znug6TFjiqhfO6NGLZWD9yAC0y4+Vid5b5ibntEyuVZpZKX5InLPNYCxd cqKQCm1ZgVYR+bNqmDW4PMWnvcH9jMbFnCBVAznggPB4Mzp12+DiG+EowoU8j9JQqH3JttJWX SmxW/GulglA4ITURGCaSfOYqtLl8wK82VaSxay/UHCbkISu90XnWpa1SrUBoyteLa8PfeoDzA HAq6/407HSrQgqsmhMA1pxt0Mka2uZM2SqL88ka91ypAySxFDr3hiz3QL2nDEiFAPDr+96BBr 2vid List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Patroni is widely used Sent from my iPhone > On Nov 12, 2025, at 10:20=E2=80=AFAM, Joseph Craig = wrote: >=20 > =EF=BB=BF > Hello, >=20 > I've got to deploy some HA deployments of Postgres and wanted to know what= the actual in production architecture was for HA deployments. I've done som= e googling and found a few different options, but wanted to see what folks t= hat actually use and support Postgres are doing these days.=20 >=20 > In my lab I'm working on a Postgres and Pgpool2 setup but having issues ma= king pgpool2 HA, so that leads me back to this group. Is that the commonly u= sed HA solution or is there another one that is used more? >=20 > Thanks, > Joe Craig >=20