Tom Lane wrote:
Joseph S <jks@xxxxxxxxxxxxxxx> 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.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
