pgpool_adm_pcp_detach_node

Name

pgpool_adm_pcp_detach_node --  a function to detach given node ID

Synopsis

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 );

Description

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

See pcp_common_options .

Example

Here is an example output:

test=# SELECT * FROM pgpool_adm_pcp_detach_node(1, 'false', 'localhost',11001,'t-ishii','t-ishii');
 node_detached
---------------
 t
(1 row)