pgpool_adm

pig repo add pgdg -u    # add pgdg repo and update cache

pig install pgpool;		# install via package name, for the active PG version
pig install pgpool_adm;		# install by extension name, for the current active PG version

pig install pgpool_adm -v 18;   # install for PG 18
pig install pgpool_adm -v 17;   # install for PG 17
pig install pgpool_adm -v 16;   # install for PG 16
pig install pgpool_adm -v 15;   # install for PG 15
pig install pgpool_adm -v 14;   # install for PG 14

CREATE EXTENSION pgpool_adm;

SELECT * FROM pgpool_adm_pcp_node_info('localhost', 9898, 'admin', 'password', 0);
SELECT * FROM pgpool_adm_pcp_node_count('localhost', 9898, 'admin', 'password');
SELECT * FROM pgpool_adm_pcp_pool_status('localhost', 9898, 'admin', 'password');

SELECT * FROM pgpool_adm_pcp_node_info(server_name := 'pgpool_server', node_id := 0);
SELECT * FROM pgpool_adm_pcp_node_count(server_name := 'pgpool_server');

-- Detach a backend node
SELECT pgpool_adm_pcp_detach_node('localhost', 9898, 'admin', 'password', 1);

-- Re-attach a backend node
SELECT pgpool_adm_pcp_attach_node('localhost', 9898, 'admin', 'password', 1);