Обсуждение: Port 5432 failed password authentication failed
Dear support team
I recently installed postgresql on my Mac operating system. After successful installation I was able to connect with the sever and all was working fine.
Few days later I attempted to log in again, and as I had forgot my master password I did a reset password reset. This was successful, but now I find
myself not able to log on to my server as this password is incorrect.
Please can you advise as how to solve this issue. I have tried different passwords but all failed. I have attached a screen shot of my error massage.
Thank You
MR R limbani
Вложения
On 05/09/2022 13:57, Rasiklal Limbani wrote: > Dear support team > I recently installed postgresql on my Mac operating system. After > successful installation I was able to connect with the sever and all was > working fine. > Few days later I attempted to log in again, and as I had forgot my > master password I did a reset password reset. This was successful, but > now I find > myself not able to log on to my server as this password is incorrect. This is a PostgreSQL issue rather than a pgAdmin one - as the message says, the password you are supplying for user "postgres" is incorrect. As the PostgreSQL server is on your local Mac, you ought to be able to change it easily. One way is to edit pg_hba.conf and set the appropriate authentication mechanism to "trust", so that a password isn't required at all.... you can then connect and set the password for the "postgres" user: alter role postgres password 'your new password'; Don't forget to change the authentication mechanism in pg_hba.conf back to what it was. Hope this helps, Ray. -- Raymond O'Donnell // Galway // Ireland ray@rodonnell.ie