I've met this with 4 roles I created:
After changing password for a user in pgAdmin III using the GUI (1), that user can not log in any more.
pgAdmin III show error message:
An error has occurred:
Error connecting to the server: FATAL: password authentication failed for user "sam"
FATAL: password authentication failed for user "sam"
My system: Postgresql 9.2 on Ubuntu 12.04
Is there any way to fix this?
(1): login with account postgres, right click user in Login Roles, go to tab 'Definition' and enter password
Best Answer
It's possible that you're being bitten by this PgAdmin bug (changelog):
This bug has been seen to set password expiry dates far in the past, such as 1/1/1970. In this case the error message when trying to connect is no different than with a wrong password.
You can check these expiry dates with:
and if they're wrong, reset them with:
and upgrade pgAdmin.