PGQD(1)

💖 PGQD(1) — the maintenance daemon for PgQ, but make it a vibe 💖

okay bestie, sit down, hydrate, because we're about to talk about pgqd, the maintenance daemon for PgQ, straight outta the General Commands Manual. this is the whole page, nothing skipped, no crumbs left behind. 🫶

---

✨ NAME ✨

pgqd — maintenance daemon for PgQ. that's it, that's the name, iconic behavior honestly 👑

---

🌸 SYNOPSIS 🌸

the way you summon it, fr fr:

pgqd [-qvd] config

pgqd [-skr] config

pgqd --ini|-h|-V

like. three whole moods. pick your fighter. 💅

---

🦋 DESCRIPTION 🦋

it runs both the ticker and the periodic maintenance for all databases inside one PostgreSQL cluster. yes, all of them. it's the main character of cluster upkeep and it does NOT do half measures. ✨

---

💅 OPTIONS 💅

every single flag, no gatekeeping:

• -q — do not log to stdout. quiet lil angel, shhh. 🤫
• -v — verbose log. it will yap (affectionately). 🗣️
• -d — daemonize the process. it leaves home and becomes its own independent being 🧚
• -s — send SIGINT to the running process to stop it. gentle but firm. 💀
• -k — send SIGTERM to the running process to stop it. less gentle, still valid. 🔥
• -r — send SIGHUP to the running process to reload the config. glow-up via signal, slay. ✨
• -h — show help. your friendly little map. 🗺️
• -V — show version. proof of existence. ⭐
• --ini — show a sample config. a starter pack, a template, a lil gift 🎀

---

🎀 CONFIGURATION 🎀

the config file uses ini file syntax, like so:

[pgqd]
logfile = ~/log/pgqd.log
pidfile = ~/pid/pgqd.pid

and here are the options, all of them, in order, no skipping:

• logfile — the filename to log to. default: empty. 🍓
• pidfile — the filename to store the pid in; it's required when daemonizing. default: empty. don't forget it or the daemon gets lost in the sauce 😭
• base_connstr — the connect string, without dbname=. default: empty.
• initial_database — the startup db used to query the other databases. default: template1
• database_list — limit the ticker to specific databases. default: empty, which means all databases (go big or go home 💅)
• syslog — whether to log into syslog. default: 1
• syslog_ident — the name to use for syslog. default: pgqd
• check_period — how often to check for new databases, in seconds. default: 60.
• retry_period — how often to flush the retry queue, in seconds. default: 30
• maint_period — how often to do maintenance, in seconds. default: 120
• ticker_period — how often to run the ticker, in seconds. default: 1

---

🌈 INSTALL 🌈

pgqd uses an autoconf based build system, so it's giving classic, it's giving timeless:

./configure --prefix=/opt
make
make install

heads up bestie: the dependencies are libevent and python3-docutils. get those first or the build will simply not. 💀

---

👑 SEE ALSO 👑

ngl there's nothing else listed here. just you, pgqd, and the cluster. iykyk. 🦋

---

and that's the whole page, bestie — signed off from the General Commands Manual, page PGQD(1), no cap. go keep that cluster cute. periodt. 💖✨🎀