> 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
> 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.
In response to
pgsql-general by date
|Next:||From: Alan Deane||Date: 2009-07-30 02:00:11|
|Subject: Re: V8.3 fails to start after unremming hba_file = 'ConfigDir/pg_hba.conf'|
|Previous:||From: Brodie Thiesfield||Date: 2009-07-30 01:53:11|
|Subject: Re: How to prevent duplicate key error when two processes do DELETE/INSERT simultaneously?|