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

Why is Server Configuration in Pgadmin3 inaccessible for me?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
whyinaccessiblepgadmin3forserverconfiguration

Problem

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.

Solution

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 ;

Context

StackExchange Database Administrators Q#139642, answer score: 5

Revisions (0)

No revisions yet.