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
# 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
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
How To Install And Configure PostgreSQL 9.5 On CentOS/RHEL 6
Reviewed by vivek sathisan
on
12:41
Rating:

No comments: