Ubuntu 10/11 Installing Postgresql 9.0 Config

sudo apt-get install python-software-properties


Next up is adding the backports repo and updating apt:

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update


UPDATE: In the comments, Jason Froebe points out that if you already have an earlier version of PostgreSQL installed, you can just upgrade it:

sudo apt-get upgrade

Finally install postgresql-9.0:

sudo apt-get install postgresql-9.0 libpq-dev

The libpq-dev package is for compiling wrappers/clients against libpq.

There you’re done!