($INBOX_DIR/description missing)
help / color / mirror / Atom feedFrom: Tatsuo Ishii <[email protected]>
To: [email protected]
Subject: pgpool: Feature: add pgpool_adm_pcp_proc_info.
Date: Tue, 24 Jun 2025 11:58:40 +0000
Message-ID: <[email protected]> (raw)
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=706ca859c64c50a47e6dc2ff31f6be22c6ce5...
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(-)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgpool: Feature: add pgpool_adm_pcp_proc_info.
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox