HiveBrain v1.2.0
Get Started
← Back to all entries
snippetsqlModerate

How to edit `postgresql.conf` with pgAdmin 3?

Submitted by: @import:stackexchange-dba··
0
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 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…

  • 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



Server Configuration > postgresql.conf">

Context

StackExchange Database Administrators Q#61193, answer score: 10

Revisions (0)

No revisions yet.