pcp_node_info

pgpool-II 3.6.3 Documentation
Prev	Up		Next

pcp_node_info -- displays the information on the given node ID

pcp_node_info [ option ...] [ node_id ]

pcp_node_info displays the information on the given node ID.

-n node_id --node-id= node_id: The index of backend node to get information of.
Other options: See pcp_common_options .

Here is an example output:

$ pcp_node_info -h localhost -U postgres 0
host1 5432 1 1073741823.500000

The result is in the following order:

1. hostname
2. port number
3. status
4. load balance weight

Status is represented by a digit from [0 to 3].

0 - This state is only used during the initialization. PCP will never display it.
1 - Node is up. No connections yet.
2 - Node is up. Connections are pooled.
3 - Node is down.

The load balance weight is displayed in normalized format.

The --verbose option can help understand the output. For example:

$ pcp_node_info --verbose -h localhost -U postgres 0
Hostname: host1
Port    : 5432
Status  : 1
Weight  : 0.5