A client has PostgreSQL 8.2.1 installed on a
Windows 2000 server.
The time on the server is correct but PostgreSQL is
returning a time 1 hour in advance. In other words, it the server time is
1:00 pm, PostgreSQL is returning 2:00 pm. Both the PostgreSQL server and
Windows server have been rebooted, but the problem remains.
postgresql.conf is using the default timezone
setting:
#timezone =
unknown # actually, defaults to TZ
# environment setting and the time zone setting on the Windows
server is (GMT - 6) Cental Time (US and Canada), which is the correct
location.
Any suggestions how to resolve this, or why its
happening?
George
|