Skip site navigation (1) Skip section navigation (2)

Re: DST question

From: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: DST question
Date: 2007-10-02 14:25:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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
> 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

In response to

pgsql-novice by date

Next:From: David MonarchiDate: 2007-10-02 22:34:39
Subject: Implicit btree index from unique constraint versus explicit btree index
Previous:From: sandy_mcd@juno.comDate: 2007-10-02 03:31:29
Subject: how to edit entries in vendor supplied database?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group