When connecting to a PostgreSQL database using pgAdmin you may receive an error letting you know that the server instrumentation is not installed. This is a warning to let you know that you can install the adminpack contribution which will provide more functionality to pgAdmin including the ability to modify the pg_hba.conf and postgresql.conf configuration files. Below is information on the pop up warning you may receive when logging into a Postgres database using pgAdmin III as well as how to install the adminpack to not receive the error any longer.
PostgreSQL: Server Instrumentation Not Installed
The above image displays the pop up warning you may receive if you have not installed the adminpack when logging into a PostgreSQL server via pgAdmin. Below are a couple steps that can be taken to install the adminpack which will allow you to modify the Postgres configuration files via pgAdmin.
Install PostgreSQL adminpack:
- Install PostgreSQL Contrib: First install the postgresql-contrib package using the yum package manager with the below syntax.
yum install postgresql-contrib
- Locate adminpack.sql: Now update your location database using “updatedb” and then locate adminpack.sql using the locate command as shown in the below example.
updatedb locate adminpack.sql
- Install adminpack: Now issue the below command to install the adminpack on your PostgreSQL server.
[root@cent2 contrib]# psql -U postgres < adminpack.sql CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION CREATE FUNCTION
- Verify adminpack Operational: Launch pgAdmin and connect to the Postgres server you just installed adminpack on. Once connected to the PSQL server click Tools in the top navigation menu, select Server Configuration from the drop down, and then select either pg_hba.conf or postgresql.conf to view a configuration file. An example pg_hba.conf is displayed in the below image.
With the adminpack contribution installed you will now be able to edit pg_hba.conf and postgresql.conf configuration files directly from pgAdmin III.