postgresql의 기본 data 경로를 /data/pgsql/data/로 변경하기(pg13 예시)
■ postgresql data directory 확인
-- pgsql에서 실행
show data_directory;■ postgresql data directory 확인
mkdir /data/pgsql/data■ postgresql data directory 확인
# postmaster.opts 수정
vi /var/lib/pgsql/13/data/postmaster.opts
/usr/pgsql-13/bin/postgres "-D" "/data/pgsql/data/"
# postgresql.conf 수정
vi /var/lib/pgsql/13/data/postgresql.conf
data_directory = '/data/pgsql/data/'
# postgresql-13.service 수정
vi /usr/lib/systemd/system/postgresql-13.service
Environment=PGDATA=/data/pgsql/data/
# bash_profile 수정
vi .bash_profile
PGDATA=/data/pgsql/data■ postgresql data directory 확인
cp -R /var/lib/pgsql/13/data/. /data/pgsql/data/.■ postgresql data directory 확인
systemctl daemon-reload
systemctl restart postgresql-13.service