Date: Tue, 06 Jan 2026 15:55:50 +0900 (JST)
Message-Id: <20260106.155550.428263298456265010.ishii@postgresql.org>
To: pgpool-committers@lists.postgresql.org
Subject: Re: pgpool: Feature: allow to specify external command to retrieve
 replicat
From: Tatsuo Ishii <ishii@postgresql.org>
In-Reply-To: <E1vd0jM-00F3PM-2h@gothos.postgresql.org>
References: <E1vd0jM-00F3PM-2h@gothos.postgresql.org>
Mime-Version: 1.0
Content-Type: Text/Plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/20260106.155550.428263298456265010.ishii%40postgresql.org>
Precedence: bulk

Oops.

> 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@tailorbrands.com>
> Reviewed-by: Tatsuo Ishii <ishii@postgresql.org>
> Discussion: https://www.postgresql.org/message-id/CACeKOO2E6cuCOQGFzq8i0%2BpFwi%3DJG4deiapHGkShjMjbn_-6tw%40mail.gmail.comxo

The last "xo" was accidentally added. Correct one:
Discussion: https://www.postgresql.org/message-id/CACeKOO2E6cuCOQGFzq8i0%2BpFwi%3DJG4deiapHGkShjMjbn_-6tw%40mail.gmail.com

> 
> 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(-)
>