Latest timezone data in 8.1.4
Hi,
At work, our production 8.1.x systems were having problems with
timezones. A new code push had newer 2006 time zones that Postgres
didn't recognize.
To fix this I built a custom RPM that overwrites the timezone data
with the latest data from nih.gov.
I changed the postgres-8.1.4-1PDG.spec file as follows:
* Add the following line to the end of the Source file section:
Source99: ftp://elsie.nci.nih.gov/pub/tzdata2006g.tar.gz
* Add the following commands to the end of the %prep section
cd src/timezone/data
tar xzvf %{SOURCE99}
Some questions...
* Is this the correct way to do this?
* Can updating the timezone data be a part of the release checklist?
* Finally, is it possible to upgrade a running server with new timezone
data?
--
Paul Lindner ||||| | | | | | | | | |
lindner@inuus.com
On Sat, Jun 10, 2006 at 05:44:37AM -0700, Paul Lindner wrote:
Some questions...
* Is this the correct way to do this?
It's as good a way as any. I have on occasion considered linking the
postgres timezone data to the system timezone data, solving this
problem.
* Can updating the timezone data be a part of the release checklist?
That would be nice. IIRC, the changed daylight savings for australia
never made any release before it actually happened.
* Finally, is it possible to upgrade a running server with new timezone
data?
Sure, it'll take effect immediatly for new backends. For existing ones
probably not.
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
Show quoted text
From each according to his ability. To each according to his ability to litigate.