pgpool_adm_pcp_detach_node3
A function to detach given node id
Usage
pcp_detach_node returns record(integer node_id, boolean gracefully, text host, integer port, text username, text password, out node_detached boolean);
pcp_detach_node returns record(integer node_id, boolean gracefully, text pcp_server, out node_detached boolean);
Overview
pcp_detach_node detaches a node from Pgpool-II.
Arguments
node_id
The index of backend node to detach.
gracefully
If true, wait for all session of pgpool-II terminates.
pcp_server
The foreign server name for pcp server.
Other arguments
Examples
Here is an example output:
test=# SELECT * FROM pcp_detach_node(node_id => 1, gracefully => 'false', host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii');
node_detached
---------------
t
(1 row)
Releases
3 releases since Debian 11 (Bullseye); the text changed 2 times.