GOLF(2gg)

💅 GOLF(2gg) — postgresql-database

okay bestie, welcome to the Golf docs, 2gg section, and today's main character is the database page 🐘✨

✨ NAME ✨

postgresql-database — Golf documentation (database)

🌸 DESCRIPTION 🌸

so like. your Postgres database config file? it holds a Postgres connection string. that's the whole vibe. 💖

if you wanna see every single parameter you could possibly put in there, they're all listed over at:

https://www.postgresql.org/docs/14/libpq-connect.html#LIBPQ-CONNSTRING

but ngl, most of the time you're only touching a couple of those options, like literally just this:

user=myuser password=mypwd dbname=mydb

okay so let's break down what that file is actually giving:

• user — the Postgres user 👤
• password — the password for that Postgres user 🔑
• dbname — the Postgres database name 🗂️

and here's the lil glow-up tip: if you're using peer-authenticated login (a.k.a. passwordless login, iykyk), then just omit password entirely. that's the situation where your Postgres user name is the exact same as your Operating System user name, and the local unix domain socket is what's doing the authentication for you. no password needed, it's giving trust fall 🫶

🦋 SEE ALSO 🦋

• Database
• begin-transaction
• commit-transaction
• current-row
• database-config-file
• db-error
• mariadb-database
• postgresql-database
• rollback-transaction
• run-query
• sqlite-database
• See all documentation

that's the whole page, bestie — go forth and connect 💜

this was $VERSION, dated $DATE — mwah, periodt 🎀✨