PSQL: 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.
Via jbranchaud/til.
Leave a comment