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

Le 24/03/2011 08:34, Jaroslav Záruba a écrit :
> Hello
>
> I have pg_dump command in cron that accesses PostgreSQL under user postgres
> and does not provide a password.
>
> pg_dump --username=postgres ...
>
> I have set in pg_hba.conf that user postgres should be trusted for all
> databases from localhost.
>
> local all postgres trust
>
> When I run the command under regular user it works.
> When I run it under root (sudo -i) it requires password, and therefore the
> crontab task fails to authenticate.
>

Are you sure the password is not asked by the sudo command, rather than
by the pg_dump one?


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