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

gracefully

pcp_server

Other arguments

EXAMPLE

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)