Postgres Pro
Downloads
Home   >   mailing lists

DST problem on Windows Server - Mailing list pgsql-general

From George Weaver
Subject DST problem on Windows Server
Date
Msg-id 00d201c7665b$d108f230$6400a8c0@Dell4500
Whole thread Raw
Responses Re: DST problem on Windows Server  (Walter Vaughan <wvaughan@steelerubber.com>)
Re: DST problem on Windows Server  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Randall Smith
Date:
Subject: quoted identifier behaviour
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: quoted identifier behaviour