mirror of
https://github.com/jbranchaud/til
synced 2026-01-02 22:58:01 +00:00
18 lines
628 B
Markdown
18 lines
628 B
Markdown
# 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:
|
|
|
|
```sql
|
|
> 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
|