From: Scott Marlowe <scott.marlowe@gmail.com>
To: DM <dm.aeqa@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Urgent PST time changing tonight
Date: Sun, 8 Mar 2009 02:29:08 -0700
Message-ID: <dcc563d10903080129l2b835c00o446ba65272dfade@mail.gmail.com> (raw)
In-Reply-To: <eae6a62a0903080053w7d59f7dcje8cfcf3212d4cd5@mail.gmail.com>
References: <eae6a62a0903072358o15b1cefdt661627cefc05b3b0@mail.gmail.com>
<dcc563d10903080023p73709f12lf64796ff81908d34@mail.gmail.com>
<eae6a62a0903080030g62f3122ax3d768518f9700600@mail.gmail.com>
<dcc563d10903080035g5e80e820sf88f2e0877ca8276@mail.gmail.com>
<eae6a62a0903080053w7d59f7dcje8cfcf3212d4cd5@mail.gmail.com>
On Sun, Mar 8, 2009 at 1:53 AM, DM <dm.aeqa@gmail.com> wrote:
> Thanks Scott,
> If i leave the system as is without any upgrade, what issues i might see any
> idea?
> do postgres has any patches for the changes. i dont want to install a new
> databae at this time, i have 1 hr to go..
> Thanks
Assuming that some update to DST got missed, then you're output will
all be off by an hour from what they should be when retrieved for that
timezone that has it wrong. I remember there being something a while
back about moving one of the timezones a few days. You can always
create and retrieve timestamps ahead of time (i.e. a timestamp in the
future) and see what offset it has to see if it's coming out right.
The real problem gets created when timestamps are inserted now for the
future. If there's a rule that we fall back 1 week off from what your
TZ data says, and you insert it today, with the old TZ on your
machine, it will be inserted as the wrong time, with the wrong offset
to get it to GMT. This cropped up a year ago with some change our
windows machines at work didn't have, and all the schedules created by
those machines were off by an hour until the newly created events
(created with the right timezone offset values) started showing up and
we got past the window where time actually did match up again.
So, leaving these to stew can be a real problem, if you're not keeping
up with the tz info.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, dm.aeqa@gmail.com
Subject: Re: Urgent PST time changing tonight
In-Reply-To: <dcc563d10903080129l2b835c00o446ba65272dfade@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox