public inbox for [email protected]  

help / color / mirror / Atom feed
Autofail back inconsistent
2+ messages / 2 participants
[nested] [flat]


* Autofail back inconsistent
@ 2025-10-29 10:09  VASUKI M <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: VASUKI M @ 2025-10-29 10:09 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]

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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Autofail back inconsistent
@ 2025-11-04 01:28  Tatsuo Ishii <[email protected]>
  parent: VASUKI M <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tatsuo Ishii @ 2025-11-04 01:28 UTC (permalink / raw)
  To: [email protected]; +Cc: [email protected]; [email protected]

Thank you for the proposal. However, this is not the best place to
discuss on new features.  Please send it to
[email protected], 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 <[email protected]>
Subject: Autofail back inconsistent
Date: Wed, 29 Oct 2025 15:39:59 +0530
Message-ID: <CACTYHzi9=_fM80pWCgGSVmXUdAkMKTpcL5yL28AY67kD32Bn2Q@mail.gmail.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


^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2025-11-04 01:28 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-10-29 10:09 Autofail back inconsistent VASUKI M <[email protected]>
2025-11-04 01:28 ` Tatsuo Ishii <[email protected]>

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