| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | pgpool-committers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pgpool: Feature: allow to specify external command to retrieve replicat |
| Date: | 2026-01-06 06:55:50 |
| Message-ID: | 20260106.155550.428263298456265010.ishii@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgpool-committers |
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(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
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(-)
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2026-01-06 11:25:21 | pgpool: Fix health check process to not start. |
| Previous Message | Tatsuo Ishii | 2026-01-06 06:39:49 | pgpool: Feature: allow to specify external command to retrieve replicat |