Skip site navigation (1) Skip section navigation (2)

Re: install zic binary

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Euler Taveira <euler(at)timbira(dot)com>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: install zic binary
Date: 2012-11-05 21:35:47
Message-ID: 20121105213547.GH19099@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
On Tue, Oct 23, 2012 at 12:40:54PM -0200, Euler Taveira wrote:
> Hi,
> 
> Every year we have a ton of questions about updating the time zone data in
> Brazil (our politics decided to do it at 90min at the second half). Problem is
> that there is not sufficient time to release a new minor version with an
> updated time zone data. It is not a problem for *nix because zic binary is
> available (even without --with-system-tzdata option) but on Windows, you are
> hosed (you have no option but build source code). Should we have pg_zic?
> 
> Sometimes we need to update time zone data but can't upgrade. Why?
> 
> * you're stacked in an unsupported version;
> * your code is relying on a strange behavior that was changed in a minor version;
> * a new minor version was released hours ago but politics decided to change
> timezone in a hurry (before a new minor version). It happened in my state
> (Tocantins) last week -- up to 48 hours before starting DST, we don't know if
> we're in or out DST. That's because the governor decided (without consulting
> the population) to be in but when people said 'no', he stepped back and
> requested the president to be out; that was too late.
> 
> 
> [1] http://mm.icann.org/pipermail/tz/2012-October/018347.html

Not sure we can adjust our process to match every politician's actions.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2012-11-05 21:37:53
Subject: Re: Pg_upgrade speed for many tables
Previous:From: Alvaro HerreraDate: 2012-11-05 21:33:16
Subject: Re: Pg_upgrade speed for many tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group