pgpool_adm_pcp_node_info

pgpool-II 3.7.1 Documentation
Prev	Up		Next

Name

pgpool_adm_pcp_node_info -- a function to display the information on the given node ID

Synopsis

pcp_node_info returns record (integer node_id , text host , integer port , text username , text password , out status text , out weight float4 );

pcp_node_info returns record (integer node_id , text pcp_server , out status text , out weight float4 );

Description

pcp_node_info displays the information on the given node ID.

Arguments

node_id: The index of backend node to get information of.
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_info(0,'',11001,'t-ishii','t-ishii');
 host | port  |      status       | weight
------+-------+-------------------+--------
 /tmp | 11002 | Connection in use |      0
(1 row)