pgpool_adm_pcp_node_info
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 pcp_node_info(0,'',11001,'t-ishii','t-ishii');
host | port | status | weight
------+-------+-------------------+--------
/tmp | 11002 | Connection in use | 0
(1 row)