Thread: 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,
isit 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/
> From each according to his ability. To each according to his ability to litigate.