public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tatsuo Ishii <[email protected]>
To: [email protected]
Cc: [email protected]
Cc: [email protected]
Cc: [email protected]
Subject: Re: Autofail back inconsistent
Date: Tue, 04 Nov 2025 20:40:38 +0900 (JST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CACTYHzhv1K1Jpe+bT0z1Oxod3d0odYW8yLuB_9q5NFyUHY6=zA@mail.gmail.com>
References: <CACTYHzhv1K1Jpe+bT0z1Oxod3d0odYW8yLuB_9q5NFyUHY6=zA@mail.gmail.com>

> Hi Pgpool-II Community,

Thank you for the proposal.

> I’ve been working with PostgreSQL for quite some time, and while managing
> backend servers with Pgpool-II, I noticed that there’s no built-in data
> synchronization before standby nodes are reattached.
> 
> To address this, I’ve developed a new enhancement for Pgpool-II 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 existing features:
> 
>    -
> 
>    *Online Recovery* – requires manual execution of pcp_recovery_node
>    -
> 
>    *Auto Failback* – may reattach inconsistent nodes without synchronization
> 
> With *Auto Resync & Reattach*, Pgpool-II ensures data safety and
> consistency during failover recovery, providing a more robust and
> self-healing HA environment.
> 
> I’ve created a dedicated GitHub repository with setup instructions,
> configuration samples, and architecture diagrams here:
>  https://github.com/BharatDBPG/pgpool2-auto-resync
> 
> The repository includes:
> 
>    -
> 
>    Enhanced failover.sh and follow_primary.sh scripts (handling both
>    primary and standby failures)
>    -
> 
>    A new resync.sh script integrating pg_rewind + WAL replay
>    -
> 
>    Sample configuration files for a *1 Primary + 2 Standby* setup
> 
> I would love to receive feedback or suggestions from the community
> regarding possible improvements or integration ideas.
> 
> I will be happy to share a patch if needed.
> Thank you for your time and support.
> 
> Best regards,
> 
> *Vasuki MCDAC,CHENNAI*
> 
> https://github.com/BharatDBPG/pgpool2-auto-resync

Yes, it would be nice to share a patch. As we follow the PostgreSQL
development model (not using GitHub), we are familiar with discussing
on a patch base.

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

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], [email protected], [email protected]
  Subject: Re: Autofail back inconsistent
  In-Reply-To: <[email protected]>

* 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