Man page - pgpool_adm_pcp_node_count(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_COUNT

NAME
SYNOPSIS
DESCRIPTION
ARGUMENTS
EXAMPLE

---

NAME

pgpool_adm_pcp_node_count - a function to retrieves number of backend nodes.

SYNOPSIS

	pcp_node_count returns integer(text host , integer port , text username , text password );
	pcp_node_count returns integer(text pcp_server );

DESCRIPTION

pcp_node_count retrieves number of DB nodes.

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_node_count(host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii');
node_count
------------
2
(1 row)

---