pg_install.sh

# http://wiki.postgresql.org/wiki/YUM_Installation
#sudo yum erase postgresql93*
cd ~
curl -O http://yum.postgresql.org/9.3/redhat/rhel-6-x86_64/pgdg-centos93-9.3-1.noarch.rpm
sudo rpm -ivh pgdg-centos93-9.3-1.noarch.rpm
rm pgdg-centos93-9.3-1.noarch.rpm
sudo yum install postgresql93-server
sudo /sbin/service postgresql-9.3 initdb --locale=en_US
sudo /sbin/chkconfig postgresql-9.3 on
sudo /sbin/service postgresql-9.3 start
sudo -u postgres psql

#postgres=> create user test createdb createuser password 'test';
#postgres=> create database test owner test;
#postgres=> \q

# vi /var/lib/pgsql/9.3/data/pg_hba.conf
# "local" is for Unix domain socket connections only
# local   all             all                                     peer
# local   all             all                                     password
# IPv4 local connections:
# host    all             test             127.0.0.1/32            md5
# host    all             all             127.0.0.1/32            ident
# host    all             all             0.0.0.0/0               password

# vi /var/lib/pgsql/9.3/data/postgresql.conf
# -> listen_addresses = '*'