Re: DST question

Thank you so much! It did work when I got the directories correct.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, October 01, 2007 7:08 PM
To: Wright, George
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] DST question

"Wright, George" <George(dot)Wright(at)infimatic(dot)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