sudo yum install postgresql-server.x86_64

sudo yum install pgadmin3.x86_64

 postgresql-setup initdb

 systemctl enable postgresql.service

## Start PostgreSQL 9.2 ##

service postgresql-9.2 start

## OR ##

/etc/init.d/postgresql-9.2 start

## Start PostgreSQL 9.2 on every boot ##

chkconfig --levels  postgresql-9.2 on

# for users connected via local IPv4 or IPv6 connections, always require md5

local  all      all          md5

sudo su postgres

createdb {db-name}

psql {db-name}

CREATE ROLE {user-name} WITH SUPERUSER LOGIN PASSWORD '{user-password}';

psql -h localhost -U {user-name} {db-name}