'PostgreSQL'에 해당되는 글 1건
CentOS 7.4에서 PostgreSQL 9.6 설치 :: 2019/07/08 11:45
1. PostgreSQL Installation by using yum
yum install -y postgresql9.6*
2. Initialize Database
/usr/pgsql-9.6/bin/postgresql96-setup initdb3. Service Registry on System Boot
systemctl start postgresql-9.64. Edit Configurations
systemctl enable postgresql-9.6
vi /var/lib/pgsql/9.6/data/pg_hba.conf5. Service Restart
host all all 127.0.0.1/0 md5
host all user 0.0.0.0/0 md5
vi /var/lib/pgsql/9.6/data/postgresql.conf
listen_address = '*'
systemctl restart postgresql-9.6