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)