hlo日記

install postgresql
ensure /varlib/pgsql space is ok
yum install  https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-redhat96-9.6-3.noarch.rpm -y
yum install postgresql96 postgresql96-server postgresql96-contrib postgresql96-libs -y
/usr/pgsql-9.6/bin/postgresql96-setup initdb
systemctl enable postgresql-9.6.service
systemctl start postgresql-9.6.service

su - postgres
psql
CREATE DATABASE dsmdb;

ALTER USER postgres with encrypted password 'your_password';
\list
\q

/var/lib/pgsql/9.6/data/pg_hba.conf
local   all             all                                     md5
host    all             all             127.0.0.1/32            md5
host    all             all             10.0.0.0/8              md5

/var/lib/pgsql/9.6/data/postgresql.conf
listen_addresses = '*'
systemctl restart  postgresql-9.6.service