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.

Basil Bourque
  • 10,806
  • 20
  • 59
  • 92
  • http://www.pgadmin.org/docs/1.18/extend.html#extend – Milen A. Radev Mar 19 '14 at 05:44
  • @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 06:58

1 Answers1

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

Basil Bourque
  • 10,806
  • 20
  • 59
  • 92