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

My pg_hba.conf looks like this:

local all postgres trust
host all postgres 192.168.1.0/24 md5
local all all ident
host all all 127.0.0.1/32 md5
host all all ::1/128 md5

2011/3/24 Guillaume Lelarge <guillaume(at)lelarge(dot)info>

> Please, answer to the list.
>

(Wrong button, I'm sorry for that.)

> 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
>