Skip to content

Latest commit

 

History

History
17 lines (13 loc) · 628 Bytes

find-the-location-of-postgres-config-files.md

File metadata and controls

17 lines (13 loc) · 628 Bytes
Raw

Find The Location Of Postgres Config Files

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.

h/t Dillon Hafer