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

This is what pops up in postgres log whenever I run the command under root,
just when I get prompted for password:
--
could not receive data from client: Connection reset by peer
--

2011/3/24 Jaroslav Záruba <jaroslav(dot)zaruba(at)gmail(dot)com>

> The command line is still the same, when executed under one user it does
> not ask for password, when executed under another (root that is) it does:
> pg_dump --ignore-version --host=localhost --port=5432 --username=postgres
> --file="$BACKUP_FILE" --format=p --column-inserts --encoding=UTF-8 db123
>
> 2011/3/24 Guillaume Lelarge <guillaume(at)lelarge(dot)info>
>
>> Le 24/03/2011 10:05, Jaroslav Záruba a écrit :
>> > 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
>> >
>> >
>>
>> Still lacks the complete pg_dump command lines (both of them, the good
>> and the bad one).
>>
>>
>> --
>> Guillaume
>> http://www.postgresql.fr
>> http://dalibo.com
>>
>
>