Thread: zic data updates

zic data updates

From
"Joachim Wieland"
Date:
Current beta seems to have the 2006k version of the zic database. The current
zic database is version 2006n however. Since this update does not include
source code but just data files I would vote to do the update in beta, what
do others think?

One prominent update concerns Brazil which changes to summer time one week
later this year (next weekend actually).


Joachim


Re: zic data updates

From
Tom Lane
Date:
"Joachim Wieland" <joe@mcknight.de> writes:
> Current beta seems to have the 2006k version of the zic database. The current
> zic database is version 2006n however. Since this update does not include
> source code but just data files I would vote to do the update in beta, what
> do others think?

Sigh, I just updated that six weeks ago ...
        regards, tom lane


Re: zic data updates

From
Bruce Momjian
Date:
Tom Lane wrote:
> "Joachim Wieland" <joe@mcknight.de> writes:
> > Current beta seems to have the 2006k version of the zic database. The current
> > zic database is version 2006n however. Since this update does not include
> > source code but just data files I would vote to do the update in beta, what
> > do others think?
> 
> Sigh, I just updated that six weeks ago ...

Tom has done the zic updates to 2006n.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


Re: zic data updates

From
Euler Taveira de Oliveira
Date:
Bruce Momjian wrote:

> Tom has done the zic updates to 2006n.
> 
What about update it to 2006o? It's from 11/06/2006 [1].

[1] ftp://elsie.nci.nih.gov/pub/

--  Euler Taveira de Oliveira http://www.timbira.com/



Re: zic data updates

From
Tom Lane
Date:
Euler Taveira de Oliveira <euler@timbira.com> writes:
> Bruce Momjian wrote:
>> Tom has done the zic updates to 2006n.
>> 
> What about update it to 2006o? It's from 11/06/2006 [1].

[ shrug... ]  And by the time we release 8.2, it'll no doubt have
changed twice more.  Folks who live in countries where DST rules change
with no notice will probably have to get used to downloading and
installing zic updates for themselves, because there's no chance that
our releases will be perfectly up to date.

For the Red Hat RPMs, I've been considering modifying the installed
file tree to link to /usr/share/zoneinfo so that Postgres would track
routine updates to the tzdata package automatically.  This relies on
knowing that the system uses the same zic database format we do, and
where it keeps it, so I fear it's not a very portable answer :-(.
But there are definitely downsides as well as upsides to maintaining
our own timezone support.
        regards, tom lane


Re: zic data updates

From
Euler Taveira de Oliveira
Date:
Tom Lane wrote:

> [ shrug... ]  And by the time we release 8.2, it'll no doubt have
> changed twice more.  Folks who live in countries where DST rules change
> with no notice will probably have to get used to downloading and
> installing zic updates for themselves, because there's no chance that
> our releases will be perfectly up to date.
> 
Maybe we need to point out somewhere in the docs how to update our zic
database. Upgrade to a newer postgresql version is not the "right"
answer though. Maybe a small note in Chapter 14 or 22?

> For the Red Hat RPMs, I've been considering modifying the installed
> file tree to link to /usr/share/zoneinfo so that Postgres would track
> routine updates to the tzdata package automatically.  This relies on
> knowing that the system uses the same zic database format we do, and
> where it keeps it, so I fear it's not a very portable answer :-(.
No, it's not. Separated projects have different directions sometimes so
it's not worth the risk.


--  Euler Taveira de Oliveira http://www.timbira.com/