postgresql13 data directory /data/pgsql/data로 변경하기
- postgresql data directory 확인
|
1 |
show data_directory; |
- data directory 생성
|
1 |
mkdir /data/pgsql/data |
- 설정파일 수정
|
1 2 3 4 5 6 7 8 9 10 11 |
vi /var/lib/pgsql/13/data/postmaster.opts /usr/pgsql-13/bin/postgres "-D" "/data/pgsql/data/" vi /var/lib/pgsql/13/data/postgresql.conf data_directory = '/data/pgsql/data/' vi /usr/lib/systemd/system/postgresql-13.service Environment=PGDATA=/data/pgsql/data/ vi .bash_profile PGDATA=/data/pgsql/data |
- 파일 복사
|
1 |
cp -R /var/lib/pgsql/13/data/. /data/pgsql/data/. |
- 서비스 재시작
|
1 2 |
systemctl daemon-reload systemctl restart postgresql-13.service |