PostgreSQL CLI Setup(sandrock.co.za)

1 pointsby chthonicdaemonw zeszłym miesiącu3 comments

sandrock.co.za

https://sandrock.co.za/carl/2026/05/my-postgresql-cli-setup/

3 comments

vineet005w zeszłym miesiącu

Good setup. One thing worth adding — pgpass file for credential management if you're connecting to multiple databases. Saves a lot of repeated password entry across environments.

chthonicdaemonw zeszłym miesiącu

`.pgpass` is the second item in the setup after `.pg_service.conf`.

chthonicdaemonw zeszłym miesiącu

Tips for making the CLI expierience nicer for PostgeSQL databases