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

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
>