Recent Posts

PSQL: Find The Data Directory

less than 1 minute read

Where does postgres store all of the data for a database cluster? Well, in its data directory. Where exactly that data directory is can depend on how the dat...

PSQL: Configure The Timezone

less than 1 minute read

Running show timezone; will reveal the timezone for your postgres connection. If you want to change the timezone for the duration of the connection, you can ...

PSQL: Use a psqlrc File For Common Settings

less than 1 minute read

There are a handful of settings that I inevitably turn on or configure each time I open up a psql session. I can save myself a little time and sanity by conf...