Search Postgresql Archives

Re: DST and potential changes thereto

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> With the U.S. Government poised to tinker with Daylight 
> Saving Time, I have a couple questions.
> 
> 0) Does PG rely on system-level TZ info or will specific 
> updates to PG be required?  I'm interested in *nix but the 
> Windows folks are probably interested, too.

Pre-8.0 relies on the system-level TZ info. So you'd need an OS update.

8.0 and later comes with it's own timezone database (which is synced
from upstream, it's not locally created). So you'd need a PostgreSQL
update for this (you could just update the timezone files and not the
rest if you wanted to, but I would assume a new minor postgresql version
wluld be put out)


> 1) However a change is implemented, what will be the effect 
> on queries for historical data? Will the localtime be correct 
> for all dates whether before or after the change?

The timezone database as imported into 8.0, and as present on many
(most?) Unix systems already handles the fact that DST rules have
changed over time. It will apply the timezone rule that was valid at the
time in question.


> Perhaps we will still dodge this bullet. But with the House 
> and Senate recently reaching an agreement, the change is 
> appearing ever more likely.

This happens all the time around the world.  It's just been a while in
the US :-)
(For example, not too many years ago a lot of countries in europe
changed their rules to be same across the EU)

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux