Setup Postgresql with hstore on Ubuntu Server 12.04 LTS.

steps.md

$ add-apt-repository ppa:pitti/postgresql
$ apt-get update
$ apt-get install postgresql libpq-dev
$ sudo -u postgres psql

postgres=# \password
Enter new password: 
Enter it again:

# Create database & user
$ sudo -u postgres psql

postgres=# create user blog with password 'secret';
CREATE ROLE
postgres=# create database blog_production owner blog;
CREATE DATABASE

# If using hstore use below command.

$ sudo su - postgres
$ psql learnaptdbprd -c 'create extension hstore;'