snippetsqlModerate
How to edit `postgresql.conf` with pgAdmin 3?
Viewed 0 times
postgresqleditconfpgadminwithhow
Problem
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
I know I've done this in older versions of Postgres.
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.
Solution
In pgAdmin…
Choose
Choose
Avoid the red-herring File menu:
Server Configuration > postgresql.conf">
- To edit the
postgresql.conffile:
Choose
Tools > Server Configuration > postgresql.conf- To edit the
pg_hba.conffile:
Choose
Tools > Server Configuration > pg_hba.confAvoid the red-herring File menu:
File>Open postgresql.conf
File>Open pg_hba.conf
Server Configuration > postgresql.conf">
Context
StackExchange Database Administrators Q#61193, answer score: 10
Revisions (0)
No revisions yet.