[pgpool-committers: 9498] pgpool: Add new field "load_balance_node" to "SHOW pool_pools" and pcp_

Tatsuo Ishii ishii at sraoss.co.jp
Mon Jul 24 20:36:01 JST 2023


Add new field "load_balance_node" to "SHOW pool_pools" and pcp_proc_info.

The new field is "1" if pgpool process is connected by a client and
the session uses the backend id as a load balance node. Users can
execute the commands to find out if there's any session that uses the
backend as the load balance node. If so, shutting down the backend may
cause session disconnection.

Discussion: https://www.pgpool.net/pipermail/pgpool-hackers/2023-July/004353.html

Note: I accidentally pushed only doc part of the commit in 4658f84870e8edfd39920f273bab1a12d71d8986.
This is a follow-up commit for actual codes.

Branch
------
master

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

Modified Files
--------------
src/include/pcp/libpcp_ext.h        |  1 +
src/tools/pcp/pcp_frontend_client.c | 10 ++++++----
src/utils/pool_health_check_stats.c |  3 ++-
src/utils/pool_process_reporting.c  |  8 +++++++-
4 files changed, 16 insertions(+), 6 deletions(-)



More information about the pgpool-committers mailing list