Installing PostgreSQL 9.1

PostgreSQL install setup

sudo sh -c "echo 'deb http://apt.postgresql.org/pub/repos/apt/ precise-pgdg main' > /etc/apt/sources.list.d/pgdg.list"
wget --quiet -O - http://apt.postgresql.org/pub/repos/apt/ACCC4CF8.asc | sudo apt-key add -
sudo apt-get update
sudo apt-get install postgresql-common
sudo apt-get install postgresql-9.3 libpq-dev

#Create a user for postgres
sudo -u postgres createuser username -s

# If you would like to set a password for the user, you can do the following
sudo -u postgres psql
postgres=# \password username