Man page - pgpool_adm_pcp_node_info(3)
Packages contas this manual
- pcp_stop_pgpool(1)
- pgpool_adm_pcp_attach_node(3)
- pcp_attach_node(1)
- pgpool_adm_pcp_node_count(3)
- pcp_recovery_node(1)
- pcp_log_rotate(1)
- pcp_detach_node(1)
- pcp_proc_info(1)
- pcp_node_info(1)
- pcp_common_options(1)
- pgpool_adm_pcp_pool_status(3)
- pg_enc(1)
- wd_cli(1)
- pgproto(1)
- pgpool_adm_pcp_health_check_stats(3)
- pcp_proc_count(1)
- pcp_watchdog_info(1)
- pcp_node_count(1)
- pcp_health_check_stats(1)
- pcp_reload_config(1)
- pcp_pool_status(1)
- pcp_invalidate_query_cache(1)
- pcp_promote_node(1)
- watchdog_setup(1)
- pgpool_setup(1)
- pgpool_adm_pcp_proc_info(3)
- pgpool_adm_pcp_node_info(3)
- pgpool_adm_pcp_detach_node(3)
- pg_md5(1)
- pgpool(8)
- pcp_stop_pgpool(1)
- pgpool_adm_pcp_attach_node(3)
- pcp_attach_node(1)
- pgpool_adm_pcp_node_count(3)
- pcp_recovery_node(1)
- pcp_log_rotate(1)
- pcp_detach_node(1)
- pcp_proc_info(1)
- pcp_node_info(1)
- pcp_common_options(1)
- pgpool_adm_pcp_pool_status(3)
- pg_enc(1)
- wd_cli(1)
- pgproto(1)
- pgpool_adm_pcp_health_check_stats(3)
- pcp_proc_count(1)
- pcp_watchdog_info(1)
- pcp_node_count(1)
- pcp_health_check_stats(1)
- pcp_reload_config(1)
- pcp_pool_status(1)
- pcp_invalidate_query_cache(1)
- pcp_promote_node(1)
- watchdog_setup(1)
- pgpool_setup(1)
- pgpool_adm_pcp_proc_info(3)
- pgpool_adm_pcp_node_info(3)
- pgpool_adm_pcp_detach_node(3)
- pg_md5(1)
- pgpool(8)
apt-get install pgpool2
apt-get install pgpool2
Manual
| PGPOOL_ADM_PCP_NODE_INFO(3) | pgpool-II 4.7.1 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 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);
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(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.7.1 |