Tuesday, July 31, 2012

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.

For creating user and database, refer this guide

No comments:

Post a Comment