Man page - pgpool_adm_pcp_pool_status(3)
Packages contains this manual
- 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)
apt-get install pgpool2
Manual
PGPOOL_ADM_PCP_POOL_STATUS
NAMESYNOPSIS
DESCRIPTION
ARGUMENTS
EXAMPLE
NAME
pgpool_adm_pcp_pool_status - a function to retrieves parameters in pgpool.conf.
SYNOPSIS
|
pcp_pool_status returns setof record(text host , integer port , text username , text password , out item text , out value text , out description text ); |
||
|
pcp_pool_status returns setof record(text pcp_server , out item text , out value text , out description text ); |
DESCRIPTION
pcp_pool_status retrieves parameters in pgpool.conf.
ARGUMENTS
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_pool_status(host => 'localhost', port =>
11001, username => 't-ishii', password => 't-ishii')
WHERE item Ë 'backend.*0';
item | value | description
-------------------------+------------------------------------------------+-------------------------------
backend_hostname0 | /tmp | backend #0 hostname
backend_port0 | 11002 | backend #0 port number
backend_weight0 | 0.500000 | weight of backend #0
backend_data_directory0 |
/home/t-ishii/work/pgpool-II/current/aaa/data0 | data
directory for backend #0
backend_status0 | 2 | status of backend #0
backend_flag0 | ALLOW_TO_FAILOVER | backend #0 flag
(6 rows)