4

My Postgres server is running (localhost:5432), but Tools > Server Configuration is greyed out for me as below. I was attempting to access it to edit/locate my postgres.conf file. Can't access Server Configuration

Basil Bourque
  • 10,806
  • 20
  • 59
  • 92
Rome_Leader
  • 143
  • 1
  • 5
  • 2
    I think you need the adminpack extension installed on the server – Neil McGuigan May 26 '16 at 19:03
  • Pursuant to postgres' assertion of a missing package of implementation tools, I thought I installed it by accepting the prompt - I guess this was not the case. Thanks! – Rome_Leader May 27 '16 at 11:10
  • 2
    @NeilMcGuigan could you detail how to install that extension in an answer? It would be helpful it it could be accepted. – Matthieu May 24 '17 at 10:31

2 Answers2

5

adminpack extension

You need to install the adminpack extension on the server.

CREATE EXTENSION IF NOT EXISTS adminpack

Tips:

  • Verify the extension is available for installation.
    SELECT * FROM pg_available_extensions ORDER BY "name" ;
  • Verify installation.
    SELECT * FROM pg_extension ORDER BY extname ;
Basil Bourque
  • 10,806
  • 20
  • 59
  • 92
Neil McGuigan
  • 8,423
  • 4
  • 39
  • 56
3

pgAdmin 4

In addition to installing create extension adminpack mentioned by @neil-mcguigan I had trouble finding the configuration values.

They have been in different places in different pgAdmin versions. (I'm currently on 4.1.6, although the question was about v3)

I'm adding this here in case someone else is looking.

  • Choose your server in the left tree pane.

  • The configuration tab is in the lower part of right side pane.

enter image description here

Basil Bourque
  • 10,806
  • 20
  • 59
  • 92
Peter Lamberg
  • 131
  • 3