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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
