(TIL) PSQL: Find The Location Of Postgres Config Files

less than 1 minute read

If you can connect to your database with psql, then you can easily find the location of your Postgres config files. After connecting, I can ask Postgres to show me where the main config file is:

> show config_file;
                                  config_file
--------------------------------------------------------------------------------
 /Users/jbranchaud/Library/Application Support/Postgres/var-9.5/postgresql.conf

In the same directory as that postgresql.conf file are a number of other configuration files such as the pg_hba.conf file.

Via jbranchaud/til.

Comments