Change Password Postgres.app on Mac
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:
- Go to the /Applications/Postgres.app/Contents/Versions/10/bin directory and execute the ./psql --u postgres command.
- Next we need to change the password throught the \password command. We need to enter the password twice times.
- 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.
0 comentarios:
Publicar un comentario