pgpool: Feature: add pgpool_adm_pcp_proc_info.

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgpool-committers(at)lists(dot)postgresql(dot)org
Subject: pgpool: Feature: add pgpool_adm_pcp_proc_info.
Date: 2025-06-24 11:58:40
Message-ID: E1uU2IR-00Gvhi-0m@gothos.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-committers

Feature: add pgpool_adm_pcp_proc_info.

This commit adds new pgpool_adm extension function:
pcp_proc_info. Also add new fields: client_host, client_port and SQL
statement to pcp_proc_info and "show pool_pools". With these additions
now it is possible to track the relationship among clients of pgpool,
pgpool itself and PostgreSQL.

Moreover the commit allows to know what commands (statements) are last
executed by using pcp_proc_info. Previously it was not possible unless
looking into the pgpool log.

lipcp.so version is bumped from 2.0 to 2.1.

Branch
------
master

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

Modified Files
--------------
doc.ja/src/sgml/ref/allfiles.sgml | 1 +
doc.ja/src/sgml/ref/pcp_proc_info.sgml | 121 +++++----
doc.ja/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml | 257 +++++++++++++++++++
doc.ja/src/sgml/ref/show_pool_pools.sgml | 183 ++++----------
doc.ja/src/sgml/reference.sgml | 1 +
doc/src/sgml/ref/allfiles.sgml | 1 +
doc/src/sgml/ref/pcp_proc_info.sgml | 118 +++++----
doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml | 271 +++++++++++++++++++++
doc/src/sgml/ref/show_pool_pools.sgml | 172 +++----------
doc/src/sgml/reference.sgml | 1 +
src/Makefile.am | 2 +
src/include/pcp/libpcp_ext.h | 17 +-
src/include/protocol/pool_proto_modules.h | 6 +-
src/libs/pcp/Makefile.am | 6 +-
src/protocol/child.c | 7 +
src/protocol/pool_proto_modules.c | 55 +++++
src/sql/pgpool_adm/Makefile | 3 +-
src/sql/pgpool_adm/pgpool_adm--1.5--1.6.sql | 61 +++++
src/sql/pgpool_adm/pgpool_adm--1.6.sql | 158 ++++++++++++
src/sql/pgpool_adm/pgpool_adm.c | 176 +++++++++++++
src/sql/pgpool_adm/pgpool_adm.control | 2 +-
src/sql/pgpool_adm/pgpool_adm.h | 5 +-
.../regression/tests/038.pcp_commands/expected | 10 +
src/test/regression/tests/038.pcp_commands/test.sh | 29 ++-
src/tools/pcp/pcp_frontend_client.c | 14 +-
src/utils/pool_health_check_stats.c | 7 +-
src/utils/pool_process_reporting.c | 18 +-
27 files changed, 1314 insertions(+), 388 deletions(-)

Browse pgpool-committers by date

  From Date Subject
Next Message Tatsuo Ishii 2025-06-25 10:37:47 pgpool: Test: fix 038.pcp_commands regression test.
Previous Message Bo Peng 2025-06-23 03:00:42 pgpool: Fix source code typos.