Re: .pgpass

<ghaverla@freenet.edmonton.ab.ca> writes:
> the message from cron indicates that home is /var/lib/postgres
> and the user is postgres when the script runs.

> X-Cron-Env: <SHELL=/bin/sh>
> X-Cron-Env: <HOME=/var/lib/postgres>
> X-Cron-Env: <PATH=/usr/bin:/bin>
> X-Cron-Env: <LOGNAME=postgres>

Hm.  Given that you seem to have eliminated other possibilities,
I guess I'd question that message.  Have you tried putting something
like "env > logfile" into the cron script to directly verify what
environment it gets?

            regards, tom lane