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 1vJD0W-00EaQD-1Y for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 15:43:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vJD0U-00Ca7T-0y for pgsql-admin@arkaria.postgresql.org; Wed, 12 Nov 2025 15:43:38 +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 1vJD0T-00Ca7L-30 for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 15:43:37 +0000 Received: from mail-yx1-xb135.google.com ([2607:f8b0:4864:20::b135]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vJD0R-007Mob-1S for pgsql-admin@lists.postgresql.org; Wed, 12 Nov 2025 15:43:37 +0000 Received: by mail-yx1-xb135.google.com with SMTP id 956f58d0204a3-63f95dc176fso920683d50.1 for ; Wed, 12 Nov 2025 07:43:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762962213; x=1763567013; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=LhtqcvYtWw25CuOzdowtUIkOjOztdBxRAfb06XmeYDc=; b=ScbLJC/X9zM4fBxCdmd/f33OidqvIrgjNhOZnW5PT2Jzy9d6ULDMKUW1PLBsEMzCoc vdxWhRaM5HgsIg2GklZtdbfeYaQF81FqkPKLhge398vVq3xWkkGryPNDgmCIzcyBwJsj h7/Z2ka4fd1rf1Fo4oRTlQvAtZlsTDubjcW4EpPCyAq0g0XkVpsS6YH+ea1sxfxdsUz3 9+BB7A4le4i3/+RAuJOIsczZBcnfeObTv9iFqrF00El5Qa7IhxpJc6OPRBRbtGCp+qm0 mWy/9dgwOEHH90oG1xEipCiNx0mwOFgHxk+mtezzMUEnrLfzMmrBkbu5V5jl4aqlN1a9 02Mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762962213; x=1763567013; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=LhtqcvYtWw25CuOzdowtUIkOjOztdBxRAfb06XmeYDc=; b=pF9U9mJ2w0qy22VTCwmHPPPrxMKTNeDdp+oUoW7xufWzKzqVsI6wrLzzlZQbRRMXXH ECGhY+HZlgM8bLx/TccxoyAjXtPjmO2zxToyJwaX0uFDg6etK/Bd1EMLrVaXl6opNOGo 1MFfLX13EURUjlDB6088uGo7eMNDHsNX8jSgE58XVFw2q6F+uA0/fb78kmAJYoU6Zks1 ERzorca5AHu1Gak1AMRfL90QK1UNYC5duxJerppG9bG7iOp5eJwwI39YbYytp3UQwNEM LXf86a05shW6NWw7WqwqFLq1GgrCyLcYKkNeI69IL9ZcaS2qWMudIcNVpERH0u14TSdV JTbw== X-Forwarded-Encrypted: i=1; AJvYcCXNEMBWekX0WDWewhyhaRVLx2VteKQglGwwpcRTR6n8cJJymlAaVztm+NkGG3F3i4Z2kMm5Q99XgN0VvA==@lists.postgresql.org X-Gm-Message-State: AOJu0YxhRb8H9XFtwmRQYXmlJDlFYQsN7v6CH05Vb96VBX9lQM68W7E0 8ucYHEX4hn3mg86MNr1ik5LUcH498/4yzNEx7MXxLvfgn6e/Vw5nj20EWH5gRnpsHHG0OSN2ED8 4L7wl8Jv0x2wkRnuYnvzpgiZqM5tFTY4= X-Gm-Gg: ASbGncukyT/AspIph9aL/wregnPQFvVUBLvTGTBucM6KevA/s/fi6V55s+erQqUQKw8 icB/Ftjye2GxowbQo+ACirQUmVILUOV50NB97UrQLeJ43EGA0BjVRF80Vk1yg0UYdqydpMaRl2e qik/lo7oy5IZ2tvRq3AmhTXvp72bi9aGT9stDCA1TQU9fv8QedC2IfFc7o+k4cjB8SpoXe44d3R AGWRpFewkDUSnd+9Wu54fp3gTAWl1IxEafyBAeU1YefyNqb3Tx0A/kcHaxjTcLtG7DXGKQ= X-Google-Smtp-Source: AGHT+IGqnH0JzoKnCGzj0ETlI2Rk15nj9GI+KnSaIqfH6GMl7yBwlWI6rhrDCj/DEpmo1bENJG6ZWTKMbAnFKeNi5mU= X-Received: by 2002:a05:690e:d8b:b0:63f:b634:5b3c with SMTP id 956f58d0204a3-64101925fcfmr2833706d50.0.1762962213335; Wed, 12 Nov 2025 07:43:33 -0800 (PST) MIME-Version: 1.0 References: <8C10A31A-EB78-48B9-B44E-5214E6D2D97D@sqlexec.com> In-Reply-To: <8C10A31A-EB78-48B9-B44E-5214E6D2D97D@sqlexec.com> From: Peter Gram Date: Wed, 12 Nov 2025 16:43:21 +0100 X-Gm-Features: AWmQ_blwnd682spWKH3I5Ukrs6_yLQwU-ckZB6_Kj79s5d_4PLZesThpR5MLfjE Message-ID: Subject: Re: Postgres HA Deployment Questions To: "MichaelDBA@sqlexec.com" Cc: Joseph Craig , pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000007a766c064367a0e4" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007a766c064367a0e4 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Have look at https://github.com/claranet/ansible-role-patroni Med venlig hilsen Peter Gram S=C3=A6byholmsvej 18 2500 Valby Mobile: (+45) 5374 7107 Email: peter.m.gram@gmail.com On Wed, Nov 12, 2025 at 16.39 MichaelDBA@sqlexec.com wrote: > Patroni is widely used > Sent from my iPhone > > > On Nov 12, 2025, at 10:20=E2=80=AFAM, Joseph Craig > wrote: > > > > =EF=BB=BF > > Hello, > > > > 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 some googling and found a few different options, but wanted to see > what folks that actually use and support Postgres are doing these days. > > > > In my lab I'm working on a Postgres and Pgpool2 setup but having issues > making pgpool2 HA, so that leads me back to this group. Is that the > commonly used HA solution or is there another one that is used more? > > > > Thanks, > > Joe Craig > > > > > > --0000000000007a766c064367a0e4 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi

Hav= e look at=C2=A0

Med venlig hilsen

Peter Gram=
S=C3=A6byholmsvej 18=C2=A0
2500 Valby

Mobile: (+45) 5374 7107

=


On Wed, Nov 12, 2025 at = 16.39 MichaelDBA@sqlexec.com = <michaeldba@sqlexec.com>= ; wrote:
Patroni is widely used
Sent from my iPhone

> On Nov 12, 2025, at 10:20=E2=80=AFAM, Joseph Craig <joe.craig83@gmail.com> w= rote:
>
> =EF=BB=BF
> Hello,
>
> I've got to deploy some HA deployments of Postgres and wanted to k= now what the actual in production architecture was for HA deployments. I= 9;ve done some googling and found a few different options, but wanted to se= e what folks that actually use and support Postgres are doing these days. <= br> >
> In my lab I'm working on a Postgres and Pgpool2 setup but having i= ssues making pgpool2 HA, so that leads me back to this group. Is that the c= ommonly used HA solution or is there another one that is used more?
>
> Thanks,
> Joe Craig
>



--0000000000007a766c064367a0e4--