| From: | George Weaver <gweaver(at)shaw(dot)ca> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | DST problem on Windows Server |
| Date: | 2007-03-14 17:11:33 |
| Message-ID: | 00d201c7665b$d108f230$6400a8c0@Dell4500 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2007-03-14 17:19:29 | Re: quoted identifier behaviour |
| Previous Message | Tom Lane | 2007-03-14 16:54:27 | Re: DST failing on 8.1.3 |