DST problem on Windows Server
| От | George Weaver |
|---|---|
| Тема | DST problem on Windows Server |
| Дата | |
| Msg-id | 00d201c7665b$d108f230$6400a8c0@Dell4500 обсуждение исходный текст |
| Ответы |
Re: DST problem on Windows Server
Re: DST problem on Windows Server |
| Список | 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
# 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 по дате отправления: