Take the 2-minute tour ×
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.

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 at 6:58

1 Answer 1

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

Your Answer

 
discard

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.