How To Change Directory Data Of Postgresql
By Admin - Selasa, 03 Mei 2011
- # service postgresql stop
- # mkdir /home/anwar/postgresql
- # chown -R postgres.postgres /home/anwar/postgresql
- # passwd
New Password:
Retype: - # su - postgres
- $ initdb -D /home/anwar/postgresql
- $ sudo su
- # service postgresql start
if you have director before:
- # service postgresql stop
- # kill postmaster
- # su - postgres
- $ postgres -D /home/anwar/postgresql
- $ sudo su
- # service postgresql start
or you can edit configuration in /etc/init.d/postgresql
looking up /var/lib/pgdata to be /home/anwar/pgdata
Follow our blog on Twitter , become a fan on Facebook . Stay updated via RSS
0 komentar for " How To Change Directory Data Of Postgresql "