install postgresql 8.4 under ubuntu with adminpack

10/2010 // Category: PostgreSQL, Ubuntu

1. basic installation of postgresql server (contrib is needed for adminpack)

sudo apt-get install postgresql

2. Install pdadmin GUI

apt-get install pgadmin3

3. Reset the password for the ‘postgres’ admin account for the server:

$ sudo su postgres -c psql template1 template1=# ALTER USER postgres WITH PASSWORD 'password'; template1=# \q

4. Change the password for the unix user ‘postgres’:

$ sudo passwd -d postgres $ sudo su postgres -c passwd

5. install adminpack

$ sudo apt-get install postgresql-contrib
$ sudo su postgres -c psql < /usr/share/postgresql/8.4/contrib/adminpack.sql
:| { Tags: }

pagetop