pgpool: Feature: allow to specify external command to retrieve replicat

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgpool-committers(at)lists(dot)postgresql(dot)org
Subject: pgpool: Feature: allow to specify external command to retrieve replicat
Date: 2026-01-06 06:39:49
Message-ID: E1vd0jM-00F3PM-2h@gothos.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-committers

Feature: allow to specify external command to retrieve replication delay.

This commit allows to specify an external command to retrieve
replication delay information for streaming replication standby nodes.
This feature is useful when backend database is a PostgreSQL
compatible third-party software which does not provide
pg_stat_replication view.

For this purpose a new GUC variable "replication_delay_source_cmd" is
added. The user provided command accepts replica node identifiers
(e.g, server1:5432 server2:5432), and prints replication delay amount
in seconds or milliseconds to stdout.

Also "replication_delay_source_timeout" GUC variable is added to give
up waiting for the command to finish if it takes long time.

Author: Nadav Shatz <nadav(at)tailorbrands(dot)com>
Reviewed-by: Tatsuo Ishii <ishii(at)postgresql(dot)org>
Discussion: https://www.postgresql.org/message-id/CACeKOO2E6cuCOQGFzq8i0%2BpFwi%3DJG4deiapHGkShjMjbn_-6tw%40mail.gmail.comxo

Branch
------
master

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

Modified Files
--------------
doc.ja/src/sgml/stream-check.sgml | 125 ++++++
doc/src/sgml/stream-check.sgml | 78 ++++
src/config/pool_config_variables.c | 23 +-
src/include/pool_config.h | 5 +-
src/sample/pgpool.conf.sample-stream | 14 +
src/streaming_replication/pool_worker_child.c | 461 ++++++++++++++++++++-
.../tests/041.external_replication_delay/README | 59 +++
.../tests/041.external_replication_delay/test.sh | 409 ++++++++++++++++++
.../041.external_replication_delay/test_parsing.sh | 54 +++
.../test_validation.sh | 323 +++++++++++++++
10 files changed, 1545 insertions(+), 6 deletions(-)

Responses

Browse pgpool-committers by date

  From Date Subject
Next Message Tatsuo Ishii 2026-01-06 06:55:50 Re: pgpool: Feature: allow to specify external command to retrieve replicat
Previous Message Bo Peng 2025-12-26 00:42:16 pgpool: Update configure file.