PGPOOL_RESET(1)

💖 NAME 💖

PGPOOL_RESET — bestie, this one puts a configuration parameter's value back to its default. That's it. That's the whole job. ✨

So like, this is the pgpool-II manual, and we're on the 4.7.2 docs, and honestly? This command is short, sweet, and a little iconic. 🎀

---

🦋 SYNOPSIS 🦋

PGPOOL RESET configuration_parameter
PGPOOL RESET ALL

---

🌸 DESCRIPTION 🌸

okay so real talk: the PGPOOL RESET command restores the value of Pgpool-II configuration parameters to the default value. 💅

and what even is "the default value" bestie? it's defined as the value that the parameter would have had, if no PGPOOL SET had ever been issued for it in the current session. so it's not like, asking the config file or whatever — it's "what would this parameter be if you hadn't been messing with it this session". vibe check passed. 🫶

this command is similar to the RESET[1] command in PostgreSQL, except there's a whole extra PGPOOL keyword bolted on to distinguish it from the PostgreSQL RESET command. like, two commands walked into a bar and they needed name tags. 😭

---

⭐ PARAMETERS ⭐

• configuration_parameter — the name of a settable Pgpool-II configuration parameter. the available ones are documented in Chapter 5, Server Configuration, in the documentation. go peek at the docs, iykyk. 👑
• ALL — resets all settable Pgpool-II configuration parameters to default values. every single one. no cap. 💀

---

✨ EXAMPLES ✨

reset the value of client_idle_limit parameter:

PGPOOL RESET client_idle_limit;

reset the value of all parameter to default:

PGPOOL RESET ALL;

---

💜 SEE ALSO 💜

• PGPOOL SET (PGPOOL_SET(1))
• PGPOOL SHOW (PGPOOL_SHOW(1))

---

🍓 NOTES 🍓

1. RESET — https://www.postgresql.org/docs/current/static/sql-reset.html

---

mwah 💖 that's the whole page. this came to you from the pgpool-II 4.7.2 docs, dated 2023, and the page itself lives at PGPOOL RESET(1) — go reset something slayfully, bestie. 🌈🦋✨