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