public inbox for [email protected]
help / color / mirror / Atom feedpgpool: Feature: allow to specify external command to retrieve replicat
2+ messages / 1 participants
[nested] [flat]
* pgpool: Feature: allow to specify external command to retrieve replicat
@ 2026-01-06 06:39 Tatsuo Ishii <[email protected]>
2026-01-06 06:55 ` Re: pgpool: Feature: allow to specify external command to retrieve replicat Tatsuo Ishii <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Tatsuo Ishii @ 2026-01-06 06:39 UTC (permalink / raw)
To: [email protected]
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 <[email protected]>
Reviewed-by: Tatsuo Ishii <[email protected]>
Discussion: https://www.postgresql.org/message-id/CACeKOO2E6cuCOQGFzq8i0%2BpFwi%3DJG4deiapHGkShjMjbn_-6tw%40mail...
Branch
------
master
Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=53844460fea156fbe1eb78a1adb87d65a8247...
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(-)
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgpool: Feature: allow to specify external command to retrieve replicat
2026-01-06 06:39 pgpool: Feature: allow to specify external command to retrieve replicat Tatsuo Ishii <[email protected]>
@ 2026-01-06 06:55 ` Tatsuo Ishii <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tatsuo Ishii @ 2026-01-06 06:55 UTC (permalink / raw)
To: [email protected]
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 <[email protected]>
> Reviewed-by: Tatsuo Ishii <[email protected]>
> Discussion: https://www.postgresql.org/message-id/CACeKOO2E6cuCOQGFzq8i0%2BpFwi%3DJG4deiapHGkShjMjbn_-6tw%40mail...
The last "xo" was accidentally added. Correct one:
Discussion: https://www.postgresql.org/message-id/CACeKOO2E6cuCOQGFzq8i0%2BpFwi%3DJG4deiapHGkShjMjbn_-6tw%40mail...
>
> Branch
> ------
> master
>
> Details
> -------
> https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=53844460fea156fbe1eb78a1adb87d65a8247...
>
> 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(-)
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-01-06 06:55 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-01-06 06:39 pgpool: Feature: allow to specify external command to retrieve replicat Tatsuo Ishii <[email protected]>
2026-01-06 06:55 ` 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