10

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.

2
  • @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? Mar 19, 2014 at 6:58

1 Answer 1

10

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

2

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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