Install PostgreSQL 9.1.4 on Ubuntu 12.04

To install PostgreSQL 9.1.4

Add already compiled ppa key
$ sudo add-apt-repository ppa:pitti/postgresql

Update you're repo & install postgres
$ sudo apt-get update
$ sudo apt-get install postgresql

Logged as postgres user and create database , user and grant all permission to users for database.

postgres$ psql template1

psql (9.1.4)

Type "help" for help.
template1=#

For creating user and database, refer this guide

http://about-opensource.blogspot.in/2011/04/postgresql-create-user-database-and.html