Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How does one edit the 'postgresql.conf' file with the pgAdmin app?

With pgAdmin 1.18.1 on Postgres 9.3.x, when I choose File > Open postgresql.conf I get a file picker dialog. And, yes, I'm connected in pgAdmin as the superuser 'postgres'.

I know I've done this in older versions of Postgres.

share|improve this question
@MilenA.Radev No help there. The 'postgres' default database already had adminpack installed. I installed adminpack on my other two databases as well. Restarted pgAdmin. But, still, when I choose File > Open postgresql.conf I get a file open picker dialog. Exactly what operation in pgAdmin is supposed to open the postgresql.conf file? – Basil Bourque Mar 19 '14 at 6:58
up vote 7 down vote accepted

In pgAdmin…

  • To edit the postgresql.conf file:
    Choose Tools > Server Configuration > postgresql.conf
  • To edit the pg_hba.conf file:
    Choose Tools > Server Configuration > pg_hba.conf

Avoid the red-herring File menu:

  • File > Open postgresql.conf
  • File > Open pg_hba.conf

screen shot of menu item: Tools > Server Configuration > postgresql.conf

share|improve this answer
holy crap. i've been using pgAdmin for 2 years and never knew that. thanks! – Neil McGuigan May 1 '15 at 3:35
(FYI when making a change, the file needs to be saved before triggering the server to reload its configuration) – Franck Dernoncourt Feb 29 at 23:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.