Change Password Postgres.app on Mac

Change Password Postgres.app on Mac

  octubre 19, 2018    martosfre

---

Before I show us how to change the password on Postgres is important say us that I used the Postgres.app  program to install Postgres on Mac. It is a tool  that let us manages the database from easy way. However the default installation doesn't include password.

To change the password  we must do the following steps:

1. Go to the /Applications/Postgres.app/Contents/Versions/10/bin directory and execute the ./psql --u postgres command.
2. Next we need to change the password throught the \password command. We need to enter the password twice times.
3. Next quit the postgres console.

4. After that we need to change the autentication method of trust to md5 in the pg_hba.conf  file  located in /Users//Library/Application Support/Postgres/var-10/pg_hba.conf, where is the username of computer.

       5. Finally we need to restart the Postgres.app, for this we must stop the database and start again.