MIME-Version: 1.0
From: VASUKI M <vasukim1992002@gmail.com>
Date: Wed, 29 Oct 2025 15:39:59 +0530
Message-ID: 
 <CACTYHzi9=_fM80pWCgGSVmXUdAkMKTpcL5yL28AY67kD32Bn2Q@mail.gmail.com>
Subject: Autofail back inconsistent
To: pgpool-general@lists.postgresql.org
Cc: bharatdb@cdac.in
Content-Type: multipart/alternative; boundary="0000000000008756060642495427"
Archived-At: 
 <https://www.postgresql.org/message-id/CACTYHzi9%3D_fM80pWCgGSVmXUdAkMKTpcL5yL28AY67kD32Bn2Q%40mail.gmail.com>
Precedence: bulk

--0000000000008756060642495427
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi Pgpool-II Community, =F0=9F=91=8B

I=E2=80=99ve been working on enhancing *Pgpool-II* by introducing a new fea=
ture
called *=E2=80=9CAutomatic Resync and Reattach=E2=80=9D*, aimed at improvin=
g high
availability and reducing manual intervention after node failures.

This feature automatically performs:

   -

   *pg_rewind synchronization* and *WAL replay* for failed or lagging
   standby nodes
   -

   *Automatic reattachment* of standby nodes once they are safely resynced

This enhancement overcomes some limitations of the existing:

   -

   *Online Recovery*, which requires manual pcp_recovery_node execution
   -

   *Auto Failback*, which may reattach inconsistent nodes without
   synchronization

With *Auto Resync & Reattach*, Pgpool-II now ensures data safety and
consistency during failover recovery, providing a more robust
high-availability environment.

I=E2=80=99ve created a dedicated repository with detailed setup instruction=
s,
configuration samples, and diagrams here:
=F0=9F=91=89 *https://github.com/BharatDBPG/pgpool2-auto-resync
<https://github.com/BharatDBPG/pgpool2-auto-resync>*

The repository includes:

   -

   Enhanced failover.sh and follow_primary.sh scripts which handles both
   primary and standby failure.
   -

   A new resync.sh script integrating pg_rewind + WAL replay
   -

   Sample configuration files for a *1 Primary + 2 Standby* setup

I=E2=80=99d love to get feedback from the community
Thanks in advance.

Best regards,
*Vasuki M*
https://github.com/BharatDBPG/pgpool2-auto-resync

--0000000000008756060642495427
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><p>Hi Pgpool-II Community, =F0=9F=91=8B</p>
<p>I=E2=80=99ve been working on enhancing <strong>Pgpool-II</strong> by int=
roducing a new feature called <strong>=E2=80=9CAutomatic Resync and Reattac=
h=E2=80=9D</strong>, aimed at improving high availability and reducing manu=
al intervention after node failures.</p>
<p>This feature automatically performs:</p>
<ul>
<li>
<p><strong><code>pg_rewind</code> synchronization</strong> and <strong>WAL =
replay</strong> for failed or lagging standby nodes</p>
</li>
<li>
<p><strong>Automatic reattachment</strong> of standby nodes once they are s=
afely resynced</p>
</li>
</ul>
<p>This enhancement overcomes some limitations of the existing:</p>
<ul>
<li>
<p><strong>Online Recovery</strong>, which requires manual <code>pcp_recove=
ry_node</code> execution</p>
</li>
<li>
<p><strong>Auto Failback</strong>, which may reattach inconsistent nodes wi=
thout synchronization</p>
</li>
</ul>
<p>With <strong>Auto Resync &amp; Reattach</strong>, Pgpool-II now ensures =
data safety and consistency during failover recovery, providing a more robu=
st high-availability environment.</p>
<p>I=E2=80=99ve created a dedicated repository with detailed setup instruct=
ions, configuration samples, and diagrams here:<br>
=F0=9F=91=89 <strong><a href=3D"https://github.com/BharatDBPG/pgpool2-auto-=
resync">https://github.com/BharatDBPG/pgpool2-auto-resync</a></strong></p>
<p>The repository includes:</p>
<ul>
<li>
<p>Enhanced <code>failover.sh</code> and <code>follow_primary.sh</code> scr=
ipts which handles both primary and standby failure.</p>
</li>
<li>
<p>A new <code>resync.sh</code> script integrating <code>pg_rewind</code> +=
 WAL replay</p>
</li>
<li>
<p>Sample configuration files for a <strong>1 Primary + 2 Standby</strong> =
setup</p>
</li>
</ul>
<p>I=E2=80=99d love to get feedback from the community=C2=A0<br>Thanks in a=
dvance.</p>
<p>Best regards,<br>
<strong>Vasuki M</strong><br>
<a href=3D"https://github.com/BharatDBPG/pgpool2-auto-resync">https://githu=
b.com/BharatDBPG/pgpool2-auto-resync</a></p></div>

--0000000000008756060642495427--