Today's Question:  What does your personal desk look like?        GIVE A SHOUT

 ALL


  Change password of postgres account in Postgres

When installing Postgres on Windows, there is some default account created for user to login. One of them is postgres, but we often don;t know what's the password for this account when we first login using this account. We need to change the password for this account. How to change it?Step 1. Modify the pg_hba.conffileGo to the /data/ and open the pg_hba.conf.# TYPE  DATABASE        USER            ADDRESS                ...

3,492 0       PASSWORD POSTGRES USER ACCOUNT