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

From DM
Subject Re: Urgent PST time changing tonight
Date
Msg-id eae6a62a0903080030g62f3122ax3d768518f9700600@mail.gmail.com
Whole thread Raw
In response to Re: Urgent PST time changing tonight  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: Urgent PST time changing tonight
List pgsql-admin
Thanks Scott for the quick response, do I need to do anything at my end to solve this issue.

People access our servers from Pacific, Central, Mountain and East Time zones.

Please let me know if i have to do any settings/configuration changes to the configuration files.

thanks
Deepak Murthy
On Sun, Mar 8, 2009 at 12:23 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
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: Scott Marlowe
Date:
Subject: Re: Urgent PST time changing tonight
Next
From: Scott Marlowe
Date:
Subject: Re: Urgent PST time changing tonight