Re: Monitoring with pg_controldata

On Wednesday 29 July 2009, Tim Uckun wrote:
>
> What is the issue here? Some sort of a timezone problem? How do I tell
> it what time zone to use?
>
> Thanks.


cron runs programs in a very limited environment. Things like TZ etc. are
usually not set. To see what your cron sets, just run a shell script with
something like

#!/bin/sh
env

and look at the email you get with the output.
Read the cron/crontab manpage. It tells you how to set environment variables
for your scripts.

HTH

    UC