PGPOOL_AD...TACH_NODE(3)

✨ NAME ✨

pgpool_adm_pcp_detach_node — bestie, this is literally the function to detach a given node ID 💅

(it lives in the pgpool_adm_pcp_detach_node(3) page of the pgpool-II 4.7.2 Documentation, iykyk)

---

🦋 SYNOPSIS 🦋

okay so here's the whole vibe, exactly as written:

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

two whole flavours of the same icon, pick ur fighter 🫶

---

💖 DESCRIPTION 💖

pcp_detach_node detaches a node from Pgpool-II. that's it, that's the whole job, and it does it flawlessly ✨

---

🎀 ARGUMENTS 🎀

• node_id — the index of the backend node you wanna detach. that one node. bye bestie 👋
• gracefully — if true, it waits for all session of pgpool-II terminates. yes we're being polite about it, we're waiting for everybody to finish up first 🧚
• pcp_server — the foreign server name for pcp server. that's the server-name route instead of spelling out all the connection deets 🌸
• Other arguments — see pcp_common_options(1). go read that one, it's giving ✨essential context✨

---

🌈 EXAMPLE 🌈

here's what an example output looks like, no cap:

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)

t as in true as in slay, the node got detached 👑

---

okay periodt, that's the whole page, you ate it, go detach some nodes responsibly 💜

this was pgpool-II 4.7.2, dated 2023, and it's the PGPOOL_AD...TACH_NODE(3) page — mwah, stan 🎀💖