Navigation :

pgpool_adm_pcp_node_count

pgpool-II 3.6.7 Documentation
Prev Up Next

Name

pgpool_adm_pcp_node_count --  a function to retrieves number of backend nodes.

Synopsis

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

pcp_node_count returns integer (text pcp_server );

Description

pcp_node_count retrieves number of DB nodes.

Arguments

pcp_server

The foreign server name for pcp server.

Other arguments

See pcp_common_options .

Example

Here is an example output: 

test=# SELECT * FROM pgpool_adm_pcp_node_count('localhost',11001,'t-ishii','t-ishii');
 node_count
------------
          2
(1 row)