Re: DST question - Mailing list pgsql-novice

From Tom Lane
Subject Re: DST question
Date
Msg-id 23960.1191280102@sss.pgh.pa.us
Whole thread Raw
In response to Re: DST question  ("Wright, George" <George.Wright@infimatic.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: "Wright, George"
Date:
Subject: Re: DST question
Next
From: "sandy_mcd@juno.com"
Date:
Subject: how to edit entries in vendor supplied database?