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

Re: 2007 DST change not working

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: 2007 DST change not working
Date: 2007-01-04 14:30:33
Message-ID: 5.2.1.1.0.20070104092626.03f46e90@pop6.sympatico.ca (view raw or flat)
Thread:
Lists: pgsql-novice
I still haven't found the zone files on my system.  The file I dumped in a 
previous message was from OS ( At the time, I thought it was the same thing).

I think I'll do the "US/Eastern" work around for now.  I notice that I must 
reload tables for this work correctly (or did I miss something)?  I'm still 
testing upgrade from 7.3.5 to 8.1.5, so reoad is not a problem this time.

I used to install from source about 5 years ago; but now I've been spoiled 
by binary packages from OpenBSD.  They have 8.1.5, but not yet 8.2 
available yet.



At 07:00 PM 1/1/07, Chad Wagner wrote:

>Frank,
>Of course you could always get brave and recompile the zone files :).  I 
>outlined a procedure on my web site:
>
><http://www.postgresqlforums.com/wiki/>http://www.postgresqlforums.com/wiki/
>
>If your interested in braving those waters.  I did perform it against 
>8.1.5 and the zone files worked fine with your test case.
>
>Perhaps this is a good excuse to give 8.2 a whirl?  :)
>
>On 1/1/07, Tom Lane <<mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>Frank Bax <<mailto:fbax(at)sympatico(dot)ca>fbax(at)sympatico(dot)ca> writes:
>> > fbax=>  show time zone;
>> >      TimeZone
>> > ----------------
>> >   Canada/Eastern
>>
>>Oh, there's your problem: as of 8.1.5's version of the zoneinfo files,
>>it wasn't clear what Canada was going to do.  Looking at our CVS history
>>it seems the zoneinfo people only did something about it in mid-2006:
>>
>>+# From Paul Eggert (2006-06-27):
>>+# For now, assume all of DST-observing Canada will fall into line with the
>>+# new US DST rules,
>>
>>This is in CVS for 8.1.6 but not released yet.  What I'd suggest is
>>grabbing the share/timezone/* files out of an 8.2.0 release, which
>>does have the update.  You might be able to get away with just copying
>>your /usr/share/zoneinfo tree into Postgres' share/timezone directory,
>>but be prepared to undo that because it could break things entirely:
>>there's more than one zoneinfo file format out there.
>>
>>Also note you need to restart the postmaster after updating zoneinfo,
>>I don't think there's any provision for noticing updates automatically.
>>
>>                         regards, tom lane
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: In versions below 8.0, the planner will ignore your desire to
>>        choose an index scan if your joining column's datatypes do not
>>        match


In response to

Responses

pgsql-novice by date

Next:From: Chad WagnerDate: 2007-01-04 15:01:27
Subject: Re: 2007 DST change not working
Previous:From: Sean DavisDate: 2007-01-04 10:58:47
Subject: Re: Storing Images

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