Question

18

rated 0 times [ 18] [ 0] / answers: 1 / hits: 18335 / 1 Year ago, thu, november 24, 2022, 1:43:13

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)?

Only authorized users can answer the question. Please sign in first, or register a free account.

Total Points: 337

Total Questions: 108

Total Answers: 105

Location: Western Sahara

Member since Mon, May 3, 2021

3 Years ago

oileweaty questions

Thu, Jul 1, 21, 01:57, 3 Years ago

Wed, Nov 24, 21, 11:48, 2 Years ago

Mon, Jun 13, 22, 04:01, 2 Years ago

Sat, Dec 24, 22, 16:51, 1 Year ago

Sat, May 14, 22, 00:50, 2 Years ago

answered 1 Year ago raldership · Accepted Answer

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;