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

I don't know why postgres is prompting for a password. But you could try
putting the following in your crontab:

su postgres -c 'pg_dump ...'

Simon

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

> 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.
>
> (I'm looking at both users' 'export' command output, and there seems to be
> nothing related to PostgreSQL.)
>
> Could someone explain to me what is happening here?
>
> Regards
> J. Záruba