PostgreSQL 9

ubuntu 10.04 + PostgreSQL 9.0 + pgAdmin III 1.12.0

1)
$ sudo vi /etc/apt/sources.list

## Postgres 9 hasn't been backported yet.  Manually added repos.
deb http://ppa.launchpad.net/pitti/postgresql/ubuntu lucid main
deb-src http://ppa.launchpad.net/pitti/postgresql/ubuntu lucid main

2)Pitt(PPA Signing Key)
$ sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys 8683D8A2

3)
$ sudo apt-get update

4)
$ sudo apt-get install postgresql-9.0
$ sudo apt-get install pgadmin3

5)server instrumentation
$ sudo apt-get install postgresql-contrib-9.0
$ sudo -u postgres psql -U postgres -d postgres < /usr/share/postgresql/9.0/contrib/adminpack.sql


Ref>
https://launchpad.net/~pitti/+archive/postgresql
http://www.cheeren.com/node/58