PGPOOL_SET(1)

💖 PGPOOL SET(1) 💖

okay bestie, welcome to the pgpool-II 4.7.2 manual, page PGPOOL SET(1). this is the one that lets you change config stuff mid-session, and honestly? it's giving main character energy. let's get into it 🫶

---

✨ NAME ✨

PGPOOL_SET — change a configuration parameter

---

🌸 SYNOPSIS 🌸

PGPOOL SET  configuration_parameter { TO | = } { value | 'value' | DEFAULT }

---

🦋 DESCRIPTION 🦋

so like, the PGPOOL SET command changes the value of Pgpool-II configuration parameters for the current session. that's it, that's the vibe.

it's basically the same as the SET[1] command in PostgreSQL, except we slapped a PGPOOL keyword on the front so nobody gets confused about which one you're talking about. no cap, that's the whole reason the keyword exists. 💅

many of the configuration parameters that live in Chapter 5, Server Configuration, in the documentation can be changed on-the-fly with PGPOOL SET, and it only affects the value used by the current session. so you're not out here rewriting the whole config for everyone, you're just doing a lil glow-up on your own session. iconic behaviour, frankly. ✨

---

🎀 EXAMPLES 🎀

change the value of client_idle_limit parameter:

PGPOOL SET client_idle_limit = 350;

reset the value of client_idle_limit parameter to default:

PGPOOL SET client_idle_limit TO DEFAULT;

change the value of log_min_messages parameter:

PGPOOL SET log_min_messages TO INFO;

look at that. three examples, all of them ate. 🔥

---

🌈 SEE ALSO 🌈

• PGPOOL RESET (PGPOOL_RESET(1))
• PGPOOL SHOW (PGPOOL_SHOW(1))

go read those too bestie, they're the sibling pages and they're lowkey obsessed with this one.

---

💜 NOTES 💜

1. SET https://www.postgresql.org/docs/current/static/sql-set.html

---

and that's the page!! 💖 this was pgpool-II 4.7.2, dated 2023, and you've been reading PGPOOL SET(1). go forth and set parameters responsibly, bestie, and remember: session-scoped changes only, no drama. mwah 🎀💅🦋