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