Re: DST question

I downloaded the archive and extracted the files, and ran zic on them
(southamerica in particular)

When I execute zdump Brazil/East I see the following:

Brazil/East  Sun Oct 21 02:59:59 2029 UTC = Sat Oct 20 23:59:59 2029 BRT
isdst=0 gmtoff=-10800
Brazil/East  Sun Oct 21 03:00:00 2029 UTC = Sun Oct 21 01:00:00 2029
BRST isdst=1 gmtoff=-7200

These appear to be the old rules. I'm not sure what I did wrong. I
rebooted PostGreSQL and the box just in case but still see the old
values.

Any ideas?


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, October 01, 2007 2:10 PM
To: Wright, George
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] DST question

"Wright, George" <George.Wright@infimatic.com> writes:
> I am trying to get Daylight Savings Time working for the EAST
Brazilian
> time zone. In Brazil for 2007, the DST change occurs on Oct. 13-14.

You need a newer version of the zic timezone database.  Way newer --- it
looks to me like the first version of the zic files that knows the above
rules is 2007h, which was released today.  You'd need to grab
ftp://elsie.nci.nih.gov/pub/tzdata2007h.tar.gz, feed it through zic,
and put the files into place in the Postgres installation tree.

<rant>
Suggestion: lobby your politicians to set DST transition dates more than
just a month in advance.  Or even (heaven forbid) have a law that stays
the same for years at a time.  Don't they realize that people have
better things to do than scramble to update their equipment at the last
minute?
</rant>

            regards, tom lane