Re: [GENERAL] Monitoring with pg_controldata

2009-07-29 Thread Tim Uckun
O > 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

Re: [GENERAL] Monitoring with pg_controldata

2009-07-29 Thread Uwe C. Schroeder
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

[GENERAL] Monitoring with pg_controldata

2009-07-29 Thread Tim Uckun
I am trying to monitor my replication lag with pg_controldata and it's driving me nuts. If I run pg_controldata from the command line as user postgres or root I get the following line Time of latest checkpoint:Thu 30 Jul 2009 00:36:12 NZST If I run it from the crontab I get this out