Postgres Pro
Downloads
Home   >   mailing lists

Production systems beware: U.S. Daylight Savings Time comes at a new time this year - Mailing list pgsql-general

From Richard Troy
Subject Production systems beware: U.S. Daylight Savings Time comes at a new time this year
Date
Msg-id Pine.LNX.4.33.0702011306270.23745-100000@denzel.in
Whole thread Raw
In response to Re: Any Plans for cross database queries on the same server?  (Mark Walker <furface@omnicode.com>)
Responses Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  (Ron Johnson <ron.l.johnson@cox.net>)
Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year  ("John D. Burger" <john@mitre.org>)
List pgsql-general
Tree view 
Hello All,

it was recently brought to my attention that last year the U.S. altered
the dates when Daylight Savings Time starts and ends. Many if not most
computers presume the old change dates and therefore, if left to change
automatically, will change at the wrong times. This will be vital for
people in the database community who manage applications that need
accurate timestamps.

You can read up on this issue here, among other places:

http://www.washingtonpost.com/wp-dyn/content/article/2007/01/31/AR2007013102318.html?referrer=emailarticle

I've never investigated how NTP servers handle DST changes - that is,
whether they switch with the fabrication that we have more daylight hours
or leave it to clients.  Hmmm...  Anybody know? It'd be nice to know that
we can trust our NTP servers to tell our systems what time it is and
therefore ignore this issue for those systems that are NTP clients.

Regards,
Richard

--
Richard Troy, Chief Scientist
Science Tools Corporation
510-924-1363 or 202-747-1263
rtroy@ScienceTools.com, http://ScienceTools.com/

pgsql-general by date:

Previous
From: "Dave Page"
Date:
Subject: Re: I "might" have found a bug on 8.2.1 win32
Next
From: Scott Marlowe
Date:
Subject: Re: Production systems beware: U.S. Daylight Savings Time comes at a new time this year