zic data updates

Started by Joachim Wielandabout 19 years ago6 messages
#1Joachim Wieland
joe@mcknight.de

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Joachim Wieland (#1)
Re: zic data updates

"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

#3Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#2)
Re: zic data updates

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. +

In reply to: Bruce Momjian (#3)
Re: zic data updates

Bruce Momjian wrote:

Tom has done the zic updates to 2006n.

What about update it to 2006o? It's from 11/06/2006 [1]ftp://elsie.nci.nih.gov/pub/.

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

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

#5Tom Lane
tgl@sss.pgh.pa.us
In reply to: Euler Taveira de Oliveira (#4)
Re: zic data updates

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

In reply to: Tom Lane (#5)
Re: zic data updates

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/