PostgreSQL 10 on CentOS6

PostgreSQL 10 on CentOS6

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-6-x86_64/pgdg-centos10-10-2.noarch.rpm

Install the client packages:

yum install postgresql10

Optionally install the server packages:

yum install postgresql10-server

Optionally initialize the database and enable automatic start:

service postgresql-10 initdb

chkconfig postgresql-10 on

service postgresql-10 start

/var/lib/pgsql/10/data/postgresql.conf

listen_addresses = '*'

/var/lib/pgsql/10/data/pg_hba.conf

host    all             all             0.0.0.0/0               md5

service postgresql-10 restart