Feature: add pgpool_adm_pcp_proc_info.
authorTatsuo Ishii <ishii@postgresql.org>
Tue, 24 Jun 2025 10:16:15 +0000 (19:16 +0900)
committerTatsuo Ishii <ishii@postgresql.org>
Tue, 24 Jun 2025 11:57:43 +0000 (20:57 +0900)
commit706ca859c64c50a47e6dc2ff31f6be22c6ce5a13
tree03e231df84bf7a8617ded16669ae809bde53f784
parent83f12e1505f95b02c89eabec55d2f9a061ccaa6b
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.
27 files changed:
doc.ja/src/sgml/ref/allfiles.sgml
doc.ja/src/sgml/ref/pcp_proc_info.sgml
doc.ja/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml [new file with mode: 0644]
doc.ja/src/sgml/ref/show_pool_pools.sgml
doc.ja/src/sgml/reference.sgml
doc/src/sgml/ref/allfiles.sgml
doc/src/sgml/ref/pcp_proc_info.sgml
doc/src/sgml/ref/pgpool_adm_pcp_proc_info.sgml [new file with mode: 0644]
doc/src/sgml/ref/show_pool_pools.sgml
doc/src/sgml/reference.sgml
src/Makefile.am
src/include/pcp/libpcp_ext.h
src/include/protocol/pool_proto_modules.h
src/libs/pcp/Makefile.am
src/protocol/child.c
src/protocol/pool_proto_modules.c
src/sql/pgpool_adm/Makefile
src/sql/pgpool_adm/pgpool_adm--1.5--1.6.sql [new file with mode: 0644]
src/sql/pgpool_adm/pgpool_adm--1.6.sql [new file with mode: 0644]
src/sql/pgpool_adm/pgpool_adm.c
src/sql/pgpool_adm/pgpool_adm.control
src/sql/pgpool_adm/pgpool_adm.h
src/test/regression/tests/038.pcp_commands/expected [new file with mode: 0644]
src/test/regression/tests/038.pcp_commands/test.sh
src/tools/pcp/pcp_frontend_client.c
src/utils/pool_health_check_stats.c
src/utils/pool_process_reporting.c