Skip site navigation (1) Skip section navigation (2)

Re: Server Time Setting

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Lane Van Ingen <lvaningen(at)ESNCC(dot)com>,"Obe, Regina DND\\MIS" <robe(dot)dnd(at)cityofboston(dot)gov>,pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: Server Time Setting
Date: 2005-09-15 16:07:26
Message-ID: 43299C3E.50603@dunslane.net (view raw or flat)
Thread:
Lists: pgsql-hackers-win32

Tom Lane wrote:

>Hmm.  I think the way that the code in pgtz.c is set up, it just assumes
>that either "Eastern Standard Time" or "Eastern Daylight Time" should
>map to our US/Eastern timezone (which is a DST-aware zone).  Running
>your system in non-DST-aware mode is what's confusing it --- the offset
>to GMT is an hour different than it "should be" at this time of year.
>
>Should pgtz.c try to detect this situation and handle it by mapping to a
>non-DST-aware internal timezone?
>
>
>  
>

I think this is a simple case of misconfiguration and I suspect fiddling 
with it would just open up the possibility of more errors. If you say 
you are in a DST timezone and you don't check the DST checkbox, and you 
set the time to summer time then you're asking for trouble. I would not 
be at all surprised if the machine's idea of UTC was an hour out 
(Windows boxes keep the RTC on local time, not UTC, which is just horrid).

cheers

andrew

In response to

Responses

pgsql-hackers-win32 by date

Next:From: Lane Van IngenDate: 2005-09-15 16:20:17
Subject: Re: Server Time Setting
Previous:From: Tom LaneDate: 2005-09-15 15:51:14
Subject: Re: Server Time Setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group