Install Postgresql 9.0 on Ubuntu 10.10

Install Postgresql 9.0 Ubuntu

sudo apt-get install python-software-propertie
s
sudo add-apt-repository ppa:pitti/postgresql

sudo apt-get update

sudo apt-get upgrade

sudo apt-get install postgresql-9.0 libpq-dev


sudo -u postgres psql

Once logged in to the SQL interface, set a password for the postgres role:

ALTER ROLE postgres WITH ENCRYPTED PASSWORD 'mypassword';

You need this password to connect to the PostgreSQL server remotely with the postgres role, as described below.

To exit the PostgreSQL shell, type:

\q