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

Re: DST question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Wright, George" <George(dot)Wright(at)infimatic(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: DST question
Date: 2007-10-01 23:08:22
Message-ID: 23960.1191280102@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"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

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2007-10-01 23:25:16
Subject: Re: PG on NFS may be just a bad idea
Previous:From: Wright, GeorgeDate: 2007-10-01 21:37:57
Subject: Re: DST question

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