Change Password Postgresql

5:34 PM , , 0 Comments

  1. Bypass login with setting /var/lib/pgsql/data/pg_hba.conf From "MD5" to "ident" (REMEMBER!: return back after finish), example:
    local all all ident
    host all all 127.0.0.1/32 ident
    host all all 0.0.0.0/0 md5
    host all all ::1/128 ident
  2. service postgresql restart
  3. su postgres
  4. psql
  5. ALTER USER postgres WITH ENCRYPTED PASSWORD 'password';
  6. \q
  7. exit
  8. service postgresql restart
Salam,

Nur Cholikul Anwar

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)