Re: Monitoring with pg_controldata - Mailing list pgsql-general

From Tim Uckun
Subject Re: Monitoring with pg_controldata
Date
Msg-id 855e4dcf0907291853m79250efcm592280bc867368e3@mail.gmail.com
Whole thread Raw
In response to Re: Monitoring with pg_controldata  ("Uwe C. Schroeder" <uwe@oss4u.com>)
List pgsql-general
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 environment variables
> for your scripts.


Thanks for the tip. It looks like the LANG environment wasn't set and
obviously pg_controldata is reliant on that.  What solved it for me
was to set LANG=en_GB.UTF-8 because that was the LANG setting in the
postgres user env.

Thanks again.

pgsql-general by date:

Previous
From: Brodie Thiesfield
Date:
Subject: Re: How to prevent duplicate key error when two processes do DELETE/INSERT simultaneously?
Next
From: "Alan Deane"
Date:
Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'