On April 14, 2006 06:58 pm, Kirti <kirti(at)unswalumni(dot)com> wrote:
> What logs do I need to check to find the problem?
Wherever your system logs the output from cron. RedHat Linux and
derivatives will have a /var/log/cron or something similar (if you happen
to be running Linux). The postgres user probably got email about it, too.
> What might be a way to
> test the script?
su - postgres
run the command
This will uncover most problems, outside of obscure path differences between
a normal login session and what cron provides. Also make sure the user is
allowed to execute cron jobs.
Your cron log most likely will tell you what went wrong, though.
--
Alan