How To Install And Configure PostgreSQL 9.5 On CentOS/RHEL 6

PostgreSQL 9.5 Released. PostgreSQL is an open source object-relational, highly scalable, SQL compliant database management system

You can find PostgreSQL repo of different versions in  http://yum.postgresql.org

Install Yum repo for postgresql 9.5

#  rpm -Uvh http://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/pgdg-redhat95-9.5-2.noarch.rpm

#  yum install postgresql95.x86_64 postgresql95-devel.x86_64 postgresql95-libs.x86_64    postgresql95-server.x86_64 postgresql95-contrib.x86_64

Initialize db for the first time

#  service postgresql-9.5 initdb  

vim /var/lib/pgsql/9.5/data/pg_hba.conf

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
host    all             all             ::1/128                 ident

Change ident/peer to trust

#  restart postgresql service

#  /etc/init.d/postgresql-9.5 restart

#  ckconfig postgresql-9.5 on