public inbox for [email protected]  

help / color / mirror / Atom feed

From: VASUKI M <[email protected]>
To: [email protected]
Cc: [email protected]
Subject: Autofail back inconsistent
Date: Wed, 29 Oct 2025 15:39:59 +0530
Message-ID: <CACTYHzi9=_fM80pWCgGSVmXUdAkMKTpcL5yL28AY67kD32Bn2Q@mail.gmail.com> (raw)

Hi Pgpool-II Community, 👋

I’ve been working on enhancing *Pgpool-II* by introducing a new feature
called *“Automatic Resync and Reattach”*, aimed at improving 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’ve created a dedicated repository with detailed setup instructions,
configuration samples, and diagrams here:
👉 *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’d love to get feedback from the community
Thanks in advance.

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Autofail back inconsistent
  In-Reply-To: <CACTYHzi9=_fM80pWCgGSVmXUdAkMKTpcL5yL28AY67kD32Bn2Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox