Re: Why pg_dump 'trust' authentication fails under root and works under another user?

Please, answer to the list.

Le 24/03/2011 09:13, Jaroslav Záruba a écrit :
> Yes, it is the password for PostgreSQL.
>
> pg_dump: [archiver (db)] connection to database "db123" failed: FATAL:
>  password authentication failed for user "postgres"
> FATAL:  password authentication failed for user "postgres"
>

The error message says the authentication method used isn't trust. Can
you tell us the complete content of your pg_hba.conf (without the
comments of course), and the exact command lines (the one that work and
the one that doesn't work).


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com