Navigation :

pgpool_adm_pcp_attach_node

pgpool-II 4.2.10 Documentation
Prev Up Next

Name

pgpool_adm_pcp_attach_node --  a function to attach given node ID

Synopsis

pcp_attach_node returns record (integer node_id , text host , integer port , text username , text password , out node_attached boolean );

pcp_attach_node returns record (integer node_id , text pcp_server , out node_attached boolean );

Description

pcp_attach_node attaches a node to Pgpool-II .

Arguments

node_id

The index of backend node to attach.

pcp_server

The foreign server name for pcp server.

Other arguments

See pcp_common_options .

Example

Here is an example output: 

    test=# SELECT * FROM pcp_attach_node(node_id => 1, host => 'localhost', port => 11001, username => 't-ishii', password => 't-ishii');
    node_attached
    ---------------
    t
    (1 row)