[CentOS 7]Postgresql 10 설치

postgresql 설치

yum install postgresql10

db 초기화

/usr/pgsql-10/bin/postgresql-10-setup initdb

에러 발생

initializing database ... /var/lib/pgsql/initdb.log is not writeable by postgres /usr/bin/postgresql-setup: line 166: /var/lib/pgsql/initdb.log: 허가 거부
failed, see /var/lib/pgsql/initdb.log

chmod 777 /var/lib/pgsql/*

sudo rm /var/lib/pgsql/init.db

에러 발생

LOG: could not open configuration file "/home/isu/pgsql/data/postgresql.conf": 허가 거부

위치를 /home아래로 변경하라.!

sudo mv /home/isu/pgsql /home
chown postgres:postgres /home/pgsql/data
sudo -u postgres initdb -D /home/pgsql/data/

db 위치 변경

sudo vi /home/isu/pgsql/data/postmaster.opts

---

useradd pgsql -d /home/pgsql
passwd pgsql
비번 : isu!!2019