DOKK / manpages / debian 12 / pgpool2 / pgpool_adm_pcp_node_info.3.en
PGPOOL_ADM_PCP_NODE_INFO(3) pgpool-II 4.3.5 Documentation PGPOOL_ADM_PCP_NODE_INFO(3)

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

pcp_node_info returns record(integer node_id, text host, integer port, text username, text password, out status text, out pg_status text, out weight float4, out role text, out pg_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 pg_status text, out weight float4, out role text, out pg_role text, out replication_delay bigint, out replication_state text, out replication_sync_state text, out last_status_change timestamp);

pcp_node_info displays the information on the given node ID.

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(1).

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       | pg_status | weight |  role   | pg_role | replication_delay | replication_state | replication_sync_state | last_status_change  
------+-------+-------------------+-----------+--------+---------+---------+-------------------+-------------------+------------------------+---------------------


 /tmp | 11003 | Connection in use | up        |    0.5 | Standby | standby |                 0 | streaming         | async                  | 2021-02-27 15:10:19
(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;


Note

pg_status, pg_role out parameters are new from Pgpool-II 4.3. If you have already installed pre-4.2 pgpool_adm extension, you can upgrade to the new one by using ALTER EXTENSION SQL command.



     ALTER EXTENSION pgpool_adm UPDATE;

2023 pgpool-II 4.3.5