DOKK / manpages / debian 12 / pgpool2 / pgpool_adm_pcp_attach_node.3.en
PGPOOL_ADM_PCP_ATTACH_NODE(3) pgpool-II 4.3.5 Documentation PGPOOL_ADM_PCP_ATTACH_NODE(3)

pgpool_adm_pcp_attach_node - a function to attach given node ID

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

pcp_attach_node attaches a node to Pgpool-II.

node_id

The index of backend node to attach.

pcp_server

The foreign server name for pcp server.

Other arguments

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)

2023 pgpool-II 4.3.5