basti wrote:
> host all all localhost md5
>
> then I get the following error:
>
> password authentication failed for user "testuser"
Aside from submitting a wrong password, a less obvious cause for this error
message is when the password is expired.
Not so long ago, there was an insidious bug in pgAdmin that caused the
password validity to be possibly set in the past when editing a user account.
This results in that "password authentication failed" error when trying to
connect with the correct password.
Here's the relevant changelog entry, from
http://www.pgadmin.org/development/changelog.php
2012-11-28 AV 1.16.1 Date picker controls returns a full timestamp by
default, which can cause inadvertent date changes
on jobs and role validty dates. Ignore the time part.
If you happen to use pgadmin, check its version and your problematic
account's validity ("valuntil" field in the pg_user view). Reset it if needed
with:
ALTER USER username VALID UNTIL 'infinity';
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org
