"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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

"Wright, George" <George.Wright@infimatic.com> writes: > 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 =3D Sat Oct 20 23:59:59 2029 BRT > isdst=3D0 gmtoff=3D-10800 > Brazil/East Sun Oct 21 03:00:00 2029 UTC =3D Sun Oct 21 01:00:00 2029 > BRST isdst=3D1 gmtoff=3D-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.=20 Did you put the files in the right place? zdump probably looks at /usr/share/zoneinfo (or local equivalent) by default. Postgres looks in $sharedir/timezone, where "pg_config --sharedir" will tell you what $sharedir is. You'll probably need to update both of those directory trees and reboot before everything in the system will notice the new rules. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster