PGPOOL(8)

👑 PGPOOL — the Pgpool-II main server (manual page, section 8)

okay bestie, sit DOWN, because this is the manual for pgpool, the Pgpool-II main server, from the pgpool-II 4.7.2 docs 💖 no cap, she's the whole foundation and she knows it.

---

✨ NAME ✨

pgpool — the Pgpool-II main server 🦋

---

✨ SYNOPSIS ✨

pgpool [option...]

pgpool [option...] stop

pgpool [option...] reload

---

✨ DESCRIPTION ✨

It's literally the Pgpool-II main server. That's the vibe. 🌸

---

✨ USAGES ✨

so pgpool runs in 3 modes: start, stop and reload. That's the whole menu, babe. 🎀

If you don't hand her stop or reload, she just assumes you meant "start". No drama, no questions asked. periodt. 💅

---

✨ COMMON OPTIONS ✨

these are the common options shared across all 3 modes, so they're always invited to the party 🫶

• -a hba_config_file, --hba-file=hba_config_file — sets the path to the pool_hba.conf config file. Mandatory if that file lives somewhere other than the standard location.
• -f config_file, --config-file=config_file — sets the path to the pgpool.conf config file. Mandatory if that file lives somewhere other than the standard location.
• -F pcp_config_file, --pcp-file=pcp_config_file — sets the path to the pcp.conf config file. Mandatory if that file lives somewhere other than the standard location.
• -k key_file, --key-file=key_file — sets the path to the .pgpoolkey file. Mandatory if you're using an AES256 encrypted password and that file lives somewhere other than the standard location and is in use.
• -h, --help — prints help. classic. 💁

---

🚀 STARTING PGPOOL-II MAIN SERVER 🚀

okay these are the options for the start mode, main character mode obviously 👑

• -d, --debug — runs Pgpool-II in debug mode. Lots of debug messages get produced. she will NOT stop yapping 🔥
• -n, --dont-detach — don't run in daemon mode, does not detach control ttys. she stays right there with you 😭
• -x, --debug-assertions — turns on various assertion checks. This is a debugging aid.
• -C, --clear-oidmaps — clears the query cache oidmaps when memqcache_method is memcached. If memqcache_method is shmem, Pgpool-II always discards oidmaps at the start-up time anyway, so this option isn't necessary. lowkey redundant, but she's there if you need her ✨
• -D, --discard-status — discards the pgpool_status file and does not restore the previous status.

⚠️ Caution — this option is testing purpose only for developers and you should genuinely not use it for anything else, bestie. If pgpool_status is accidentally removed, Pgpool-II may go into split-brain (there are multiple primary servers exist). we do NOT want that 💀

---

🛑 STOPPING PGPOOL-II MAIN SERVER 🛑

these are the options for stop mode. time to close the tab on her 🥲

• -m shutdown_mode, --mode=shutdown_mode — stops Pgpool-II. shutdown_mode is either smart, fast or immediate.
  • If smart is specified, Pgpool-II will wait for all clients are disconnected. so polite, so patient 🧚
  • If fast or immediate are specified, Pgpool-II immediately stops itself without waiting for all clients are disconnected. byeeee 💨
  • There's no difference between fast and immediate in the current implementation. fr fr, they're twins.

---

🔄 RELOADING PGPOOL-II CONFIGURATION FILES 🔄

Reload the configuration file of Pgpool-II. ✨

There are no specific options for reload mode — the common options are applicable. that's it, that's the whole section, she's lowkey the chillest mode 🌈

---

and that's the whole page, bestie, you ate that 🍓

for the record: this is from the pgpool-II 4.7.2 documentation, dated 2023, and it's PGPOOL(8) — go off, icon 💜