pgpool_adm_pcp_node_info

pgpool-II 4.2.10 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 , out role text , out replication_delay bigint , out replication_state text , out replication_sync_state text , out last_status_change timestamp );

pcp_node_info returns record (integer node_id , text pcp_server , out status text , out weight float4 , out role text , out replication_delay bigint , out replication_state text , out replication_sync_state text , out last_status_change timestamp );

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(node_id => 1, host => '', port => 11001, username => 't-ishii', password => 't-ishii');
    host | port  |      status       | weight |  role   | replication_delay | replication_state | replication_sync_state | last_status_change  
    ------+-------+-------------------+--------+---------+-------------------+-------------------+------------------------+---------------------
    /tmp | 11003 | Connection in use |     0.5 | Standby |                 0 | streaming         | async                  | 2019-04-23 15:02:46
    (1 row)

Note: role , replication_delay , last_status_change out parameters are new from Pgpool-II 4.0. If you have already installed pre-4.0 pgpool_adm extension, you can upgrade to the new one by using ALTER EXTENSION SQL command.
     ALTER EXTENSION pgpool_adm UPDATE;
    

Note: replication_state and replication_sync_state out parameters are new from Pgpool-II 4.1. If you have already installed pre-4.1 pgpool_adm extension, you can upgrade to the new one by using ALTER EXTENSION SQL command.
     ALTER EXTENSION pgpool_adm UPDATE;
    