PostgreSQL 9.1 adminpack install

Question

everywhere I see guides for postgre, it seems to be on version 8.4. In that case the instruction is:

sudo -u postgres psql < /usr/share/postgresql/8.4/contrib/adminpack.sql

that location doesn't exist in the 9.1 directory apparently.

Can anyone point me how to get it working (needed for pgadmin)?

Answer 1

admin pack can be found in /usr/share/postgresql/9.1/extension

To install

sudo -u postgres psql

CREATE EXTENSION adminpack;

Also to see a list of installed extensions select * from pg_extension;