<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