How To Change Directory Data Of Postgresql

9:35 PM 0 Comments

  1. # service postgresql stop
  2. # mkdir /home/anwar/postgresql
  3. # chown -R postgres.postgres /home/anwar/postgresql
  4. # passwd
    New Password:
    Retype:
  5. # su - postgres
  6. $ initdb -D /home/anwar/postgresql
  7. $ sudo su
  8. # service postgresql start
if you have director before:
  1. # service postgresql stop
  2. # kill postmaster
  3. # su - postgres
  4. $ postgres -D /home/anwar/postgresql
  5. $ sudo su
  6. # service postgresql start
or you can edit configuration in /etc/init.d/postgresql
looking up /var/lib/pgdata to be /home/anwar/pgdata

Install Server Networking Programming

Support you how to install server, networking and Programming Easy

0 comments:

You can post comment with english language or indonesia language.
Anda bisa memberikan komentar dalam bahasa inggris atau bahasa indonesia.

Subscribe to: Post Comments (Atom)