Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 08202633559 for ; Sun, 8 Mar 2009 05:24:00 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 98351-09 for ; Sun, 8 Mar 2009 05:23:54 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from yx-out-2324.google.com (yx-out-2324.google.com [74.125.44.28]) by mail.postgresql.org (Postfix) with ESMTP id 1936163274C for ; Sun, 8 Mar 2009 05:23:49 -0300 (ADT) Received: by yx-out-2324.google.com with SMTP id 3so575158yxj.73 for ; Sun, 08 Mar 2009 00:23:48 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=zR7rS8NJX2SoFdsBOhU7lhIMlrki7fENcvtbKjtb2K8=; b=R7XhAtzX3Fz+WSRz5MBFsief7YhB4g9JuPdddj2eSdWZa8FZSB7UYvvoa47ByJyR9p tD0VNZB6q1qywwtth5k01VoYRhASZRGh97Gz4eDgOPeAXiMs4KrzUhA3Udd7TjlEDb+o e/1djAm9YviOCPVPbChl0iex/+Fa1/kk4bjiQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=KMPfeS2hlHzwHXD/8J7eSB9mEFhMIAgxAxGJtOO9dUNLI5lbYZb9o0rFRmIhCxjfNP BZdsOIG7sYZ45jGbWRYy+vhiZ0Tjym5pOyB52TlIdANzcdp5kl4XbCs0HMo9LPESOccv /AKceuYsmkgI8+uFdb9Agu9yqpjdD6aI/bZl0= MIME-Version: 1.0 Received: by 10.151.42.13 with SMTP id u13mr8253202ybj.130.1236500628343; Sun, 08 Mar 2009 00:23:48 -0800 (PST) In-Reply-To: References: Date: Sun, 8 Mar 2009 01:23:48 -0700 Message-ID: Subject: Re: Urgent PST time changing tonight From: Scott Marlowe To: DM Cc: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/108 X-Sequence-Number: 31608 On Sun, Mar 8, 2009 at 12:58 AM, DM 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.