[pgpool-committers: 5917] pgpool: Feature: auto failback

Takuma Hoshiai hoshiai at sraoss.co.jp
Mon Jul 22 09:46:41 JST 2019


Feature: auto failback

In Pgpool-II 4.1 or later, you can reattach backend nodethat is status DOWN automatically if auto_failback set on, this future is enabled.

The Feature of auto_failback require that backend node of PostgreSQL are 9.1 or later with streaming-replication mode, and sr_check process and health_check is enabled.

It do health check for standby node, when status of standby Node is down but status of streaming replication between primary and standby is 'stream'. If health check is success, execute process of fail_back automatically. This featurel is usefull for health check is failed bacause of tempolary network error is happened for example.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=3e2ecc970864056ff054799cac57ad5b30312c48

Modified Files
--------------
doc.ja/src/sgml/failover.sgml                 | 68 +++++++++++++++++++++++++++
doc/src/sgml/failover.sgml                    | 46 ++++++++++++++++++
src/config/pool_config_variables.c            | 21 +++++++++
src/include/pool_config.h                     |  4 ++
src/main/health_check.c                       | 33 ++++++++++++-
src/protocol/child.c                          |  4 +-
src/sample/pgpool.conf.sample                 |  7 +++
src/sample/pgpool.conf.sample-logical         |  7 +++
src/sample/pgpool.conf.sample-master-slave    |  7 +++
src/sample/pgpool.conf.sample-replication     |  7 +++
src/sample/pgpool.conf.sample-stream          |  6 +++
src/streaming_replication/pool_worker_child.c | 26 +---------
src/utils/pool_process_reporting.c            | 10 ++++
13 files changed, 219 insertions(+), 27 deletions(-)



More information about the pgpool-committers mailing list