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
