Thread: install zic binary

install zic binary

From
Euler Taveira
Date:
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


--   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/  PostgreSQL: Consultoria, Desenvolvimento,
Suporte24x7 e Treinamento
 



Re: install zic binary

From
Bruce Momjian
Date:
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@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +