PostgreSQL 9.0 final was released on 2010/09/20 which I’ve been waiting for to begin playing with it and evaluating it. The mainline Ubuntu Lucid apt repositories only have 8.4. According to the package maintainer, Martin Pitt, the postgresql-9.0 package won’t be added until Ubuntu Natty. Thankfully, he setup a backports repo for Ubuntu that we can pull from.
This is a very quick and painless process. If you have not done so already, make your life easier by installing python-software-properties:
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!
NOTE:
Default config directory is: /etc/postgresql/9.0/main
Default data directory is: /var/lib/postgresql/9.0/main
Pingback: Tweets that mention Installing PostgreSQL 9.0 on Ubuntu 10.04 « Dctr Watson -- Topsy.com()
Pingback: How to install PostgreSQL 9 on Ubuntu Linux 10.04/10.10 | Jason L. Froebe - Tech tips and How Tos for Fellow Techies()
Pingback: Ubuntu – PostgreSQL failing with no error message | Coding Answers()
Pingback: Rian Shin's personal blog()
Pingback: Ubuntu – PostgreSQL failing with no error message - Admins Goodies()
Pingback: Link dump for September 7th | The Queue Incorporated()
Pingback: Upgrade PostgreSql 8.4 to 9.1 | Programming Notes()