Man page - pgpool_adm_pcp_node_info(3)

Packages contains this manual

Package:  pgpool2
apt-get install pgpool2

Manuals in package:
• pcp_invalidate_query_cache(1)
• pgpool_adm_pcp_node_count(3)
• pcp_proc_info(1)
• pcp_recovery_node(1)
• pcp_common_options(1)
• pgpool_adm_pcp_pool_status(3)
• pcp_proc_count(1)
• pcp_log_rotate(1)
• pgpool_adm_pcp_node_info(3)
• pgpool_adm_pcp_attach_node(3)
• pcp_stop_pgpool(1)
• pcp_node_count(1)
• pgpool_setup(1)
• pcp_health_check_stats(1)
• pgpool_adm_pcp_detach_node(3)
• pgpool_adm_pcp_health_check_stats(3)
• pg_md5(1)
• pcp_promote_node(1)
• pcp_pool_status(1)
• pcp_detach_node(1)
• wd_cli(1)
• pg_enc(1)
• pcp_reload_config(1)
• pgpool_adm_pcp_proc_info(3)
• pcp_watchdog_info(1)
• pgproto(1)
• pgpool(8)
• watchdog_setup(1)
• pcp_node_info(1)
• pcp_attach_node(1)
Documentations in package:
• pgpool2

Manual

PGPOOL_ADM_PCP_NODE_INFO

NAME
SYNOPSIS
DESCRIPTION
ARGUMENTS
EXAMPLE

---

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

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

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;

---