Search Postgresql Archives

DST problem on Windows Server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux