table of contents
PGPOOL_ADM_PCP_NODE_INFO(3) | pgpool-II 4.1.4 Documentation | PGPOOL_ADM_PCP_NODE_INFO(3) |
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
pcp_server
Other arguments
EXAMPLE¶
Here is an example output:
test=# SELECT * FROM pcp_node_info(1,'',11001,'t-ishii','t-ishii');
host | port | status | weight | role | replication_delay | replication_state | replication_sync_state | last_status_change
------+-------+-------------------+--------+---------+-------------------+-------------------+------------------------+---------------------
/tmp | 11003 | Connection in use | 0 | 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;
2020 | pgpool-II 4.1.4 |