Reference

pgpool-II 3.6.2 Documentation
Prev	Home		Next

This part contains reference information for the Pgool-II .

The reference entries are also available as traditional "man" pages.

Table of Contents

I. Server commands

pcp_common_options -- common options used in PCP commands
pcp_node_count -- displays the total number of database nodes
pcp_node_info -- displays the information on the given node ID
pcp_watchdog_info -- displays the watchdog status of the Pgpool-II
pcp_proc_count -- displays the list of Pgpool-II children process IDs
pcp_proc_info -- displays the information on the given Pgpool-II child process ID
pcp_pool_status -- displays the parameter values as defined in pgpool.conf
pcp_detach_node -- detaches the given node from Pgpool-II. Exisiting connections to Pgpool-II are forced to be disconnected.
pcp_attach_node -- attaches the given node to Pgpool-II.
pcp_promote_node -- promotes the given node as new master to Pgpool-II
pcp_stop_pgpool -- terminates the Pgpool-II process
pcp_recovery_node -- attaches the given backend node with recovery

pg_md5 -- produces encrypted password in md5
pgpool_setup -- Create a temporary installation of Pgpool-II cluster
watchdog_setup -- Create a temporary installation of Pgpool-II clusters with watchdog

PGPOOL SHOW -- show the value of a configuration parameter
PGPOOL SET -- change a configuration parameter
PGPOOL RESET -- restore the value of a configuration parameter to the default value
SHOW POOL STATUS -- sends back the list of configuration parameters with their name, value, and description
SHOW POOL NODES -- sends back a list of all configured nodes
SHOW POOL_PROCESSES -- sends back a list of all Pgpool-II processes waiting for connections and dealing with a connection
SHOW POOL_POOLS -- sends back a list of pools handled by Pgpool-II .
SHOW POOL_VERSION -- displays a string containing the Pgpool-II release number.
SHOW POOL_CACHE -- displays cache storage statistics