Обсуждение: Port 5432 failed password authentication failed

Поиск
Список
Период
Сортировка

Port 5432 failed password authentication failed

От
Rasiklal Limbani
Дата:
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


Вложения

Re: Port 5432 failed password authentication failed

От
Ray O'Donnell
Дата:
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