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.zaruba@gmail.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