Installing PostgreSQL 9.1 on Ubuntu 11.04

The page gives a command sequence for installing PostgreSQL 9.1 on Ubuntu 11.04. It starts by installing python-software-properties, then adds the pitti/postgresql PPA and updates apt before installing postgresql-9.1 and libpq-dev.

Reading notes

#

• Install python-software-properties first.
• Add the pitti/postgresql repository and run apt-get update.
• Install postgresql-9.1 and libpq-dev.
• Switch to the postgres user, open psql on the postgres database, and set the postgres password.
• Install pgadmin3 as a GUI client for PostgreSQL.