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

[Jaroslav ZÃruba <jaroslav.zaruba@xxxxxxxxx>]

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

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