Postgres find configuration files in linux

Question

I've spent lots of time to find Postgres configuration files like pg_hba.conf or postgresql.conf in different distributions of linux and also postgres versions itself! and I was very confused...

Nemgathos · Accepted Answer · 2023-04-17 20:28:59Z

22

Finally, I found the global solution for it.

First, you should follow these steps:

Type su - postgres or, if that does not work, sudo -i -u postgres and hit Enter.
Type psql and hit Enter.

To find out the location of the postgres configuration file postgresql.conf, type:

SHOW config_file;

The output should be like this:

postgres=# SHOW config_file;
               config_file               
-----------------------------------------
 /etc/postgresql/9.6/main/postgresql.conf
(1 row)

And to find out the location of the postgres pg_hba.conf file, type:

SHOW hba_file;

There, the output should be like this:

postgres=# SHOW hba_file;
              hba_file               
-------------------------------------
 /etc/postgresql/9.6/main/pg_hba.conf
(1 row)

edited Apr 17, 2023 at 20:28

Nemgathos

6351 gold badge6 silver badges16 bronze badges

answered Dec 13, 2017 at 10:24

S.Hossein Asadollahi

1,7103 gold badges18 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vao Tsun · Accepted Answer · 2017-12-13 12:29:04Z

3

If you instance is not started and you can't

select current_setting('hba_file')

or

select setting from pg_settings where name = 'hba_file'

or

psql -c 'show hba_file'

you can just find them:

find / -name pg_hba.conf

answered Dec 13, 2017 at 12:29

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

Collectives™ on Stack Overflow

Postgres find configuration files in linux

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related