Thank you so much! It did work when I got the directories correct.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, October 01, 2007 7:08 PM
To: Wright, George
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] DST question
"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
