Tom Lane wrote:
> Joseph S <jks@selectacast.net> writes:
>> On one of my servers postgres thinks that we're back on standard time
>> already:
>
> What's its TimeZone setting?
On the server that is working:
=> show TimeZone;
TimeZone
------------
US/Eastern
(1 row)
On the one that is broken:
show TimeZone;
TimeZone
------------
posixrules
(1 row)
What is the mod date of the corresponding
> file in the $SHAREDIR/timezone/ directory (where $SHAREDIR means
> whatever pg_config --sharedir says)?
>
The problem seems to have been that universal read permission (and on
the directories execute permission) was not granted on the
$SHAREDIR/timezone/ directory structure during install. I fixed the
permissions and restarted postgres and now everything is fine.
