Re: [NOVICE] 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.

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

<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

---------------------------(end of broadcast)---------------------------

               http://archives.postgresql.org Received on Mon Oct 1 17:52:13 2007