DOKK / manpages / debian 12 / pgpool2 / pgpool_adm_pcp_node_count.3.en
PGPOOL_ADM_PCP_NODE_COUNT(3) pgpool-II 4.3.5 Documentation PGPOOL_ADM_PCP_NODE_COUNT(3)

pgpool_adm_pcp_node_count - a function to retrieves number of backend nodes.

pcp_node_count returns integer(text host, integer port, text username, text password);

pcp_node_count returns integer(text pcp_server);

pcp_node_count retrieves number of DB nodes.

pcp_server

The foreign server name for pcp server.

Other arguments

See pcp_common_options(1).

Here is an example output:



    test=# SELECT * FROM pcp_node_count(host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii');


    node_count


    ------------


    2


    (1 row)

2023 pgpool-II 4.3.5