Re: Autofail back inconsistent

Thank you for the proposal. However, this is not the best place to
discuss on new features. Please send it to
pgpool-hackers(at)lists(dot)postgresql(dot)org, where pgpool developers lives.

Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

From: VASUKI M <vasukim1992002(at)gmail(dot)com>
Subject: Autofail back inconsistent
Date: Wed, 29 Oct 2025 15:39:59 +0530
Message-ID: <CACTYHzi9=_fM80pWCgGSVmXUdAkMKTpcL5yL28AY67kD32Bn2Q(at)mail(dot)gmail(dot)com>

> 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