Re: Urgent PST time changing tonight - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Urgent PST time changing tonight
Date
Msg-id dcc563d10903080023p73709f12lf64796ff81908d34@mail.gmail.com
Whole thread Raw
In response to Urgent PST time changing tonight  (DM <dm.aeqa@gmail.com>)
Responses Re: Urgent PST time changing tonight  (DM <dm.aeqa@gmail.com>)
List pgsql-admin
On Sun, Mar 8, 2009 at 12:58 AM, DM <dm.aeqa@gmail.com> wrote:
> Hi All,
> PST time changing tonight, I am not sure if this is going to affect the
> database.
> Please throw some light if the time change affect on our production system.
> Briefly - We have 2 production database servers with postgresql 8.3.3 and
> pgpool 2.1 version running.

pg includes its own tz data files, so running 8.3.3 might be some
issue if you handle odd timezones, but generally the dst offset change
is no big deal.  all the timestamps are stored internally in gmt.

pgsql-admin by date:

Previous
From: DM
Date:
Subject: Urgent PST time changing tonight
Next
From: DM
Date:
Subject: Re: Urgent PST time changing tonight