Re: Urgent PST time changing tonight

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: DM <dm(dot)aeqa(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Urgent PST time changing tonight
Date: 2009-03-08 08:23:48
Message-ID: dcc563d10903080023p73709f12lf64796ff81908d34@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Mar 8, 2009 at 12:58 AM, DM <dm(dot)aeqa(at)gmail(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message DM 2009-03-08 08:30:43 Re: Urgent PST time changing tonight
Previous Message DM 2009-03-08 07:58:45 Urgent PST time changing tonight