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

3
  • 2
    I think you need the adminpack extension installed on the server May 26, 2016 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! May 27, 2016 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, 2017 at 10:31

2 Answers 2

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 ;
1
  • P.S. Azure blocks this for PostgreSQL hosted on their cloud =/
    – VSO
    Jan 13, 2020 at 21:29
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

0

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.