Ubuntu – pgadmin III doesn’t work due to “The server lacks instrumentation functions.”

postgresql

When pgAdmin III is used to open a PostgreSQL database the following message appears.
There does not seem to be any obvious package listed in the Ubuntu Software Center for this.

The server lacks instrumentation functions.

pgadmin III uses some support functions that are not available by default in all PostgreSQL versions. These enable some tasks that make life easier when dealing with log files and configuration files.

The adminpack is installed and activated by default if you are running the one-click installer of PostgreSQL. On Unix, you may have to install the contrib package, either with your package installer tool or by compilation.

Best Answer

I believe the package which needs to be installed is called postgresql-contrib. Install it with

sudo apt-get install postgresql-contrib