cvm-pgsql(8)

📦 version 0.97, in debian bookworm, ubuntu jammy, ubuntu noble, ubuntu questing, ubuntu resolute, ubuntu stonking

💖 cvm-pgsql — the PgSQL module 💖

okay bestie, welcome to cvm-pgsql(8), straight out of the System Manager's Manual. it's a CVM module. it talks to Postgres. it's giving database girlie and honestly? iconic. let's get into it 🫶

✨ SYNOPSIS ✨

cvm-pgsql

that's it. that's the whole thing. no flags, no args, she just runs. main character energy fr fr 💅

🔑 CREDENTIALS 🔑

Pass phrase — that's what this module wants from you. the vibes, the secret, the lil password moment. 🌸

📖 DESCRIPTION 📖

so here's the tea ☕ — this module goes and queries a PgSQL database to find the account name, then it takes the pass phrase that's stored in there and compares it against the pass phrase you gave it, using crypt(3). classic. secure. no cap. 🔥

⚙️ CONFIGURATION VARIABLES ⚙️

the server hostname, the port, the database, the username, the password, and any additional options? all of that can be controlled by setting these bad boys respectively:

  • $PGHOST
  • $PGPORT
  • $PGDATABASE
  • $PGUSER
  • $PGPASSWORD
  • $PGOPTIONS

and yes, they get parsed by the PgSQL client library itself, so it's all very official and handled. 👑

🎀 CVM_MYSQL_POSTQ (optional) 🎀

the SQL query to execute after the credentials have been validated. see cvm-sql(7) for the deets.

yes bestie, it says CVM_MYSQL_POSTQ in the PgSQL module. that's not a typo on my part, that's literally what the page says, so I'm passing it to you verbatim. 💀

🎀 CVM_PGSQL_PWCMP (optional) 🎀

the password comparison module to use. pick your fighter. 🥊

🎀 CVM_PGSQL_QUERY (optional) 🎀

the SQL query to issue to retrieve the row containing the account information from the database. i.e. go fetch the receipts. 🧾✨

👀 SEE ALSO 👀

go read these next, they're all part of the extended universe:

and the links, exactly as they were handed to me:

💖 that's the whole page bestie. every flag, every variable, every path, every reference — all accounted for. nothing dropped, nothing invented. periodt. 💖

mwah 💋 this was cvm-pgsql(8) from the System Manager's Manual — that's the source and the version, right there in the corner, and yes it's the same name as the title because that's how these pages do. slay. 🎀✨🦋

📦 where this page comes from