Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 000FC9FB620 for ; Thu, 1 Mar 2007 16:53:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 13889-04 for ; Thu, 1 Mar 2007 16:53:26 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id B8BA49FB5C2 for ; Thu, 1 Mar 2007 16:53:28 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l21KrQ38016653; Thu, 1 Mar 2007 15:53:26 -0500 (EST) To: Pallav Kalva cc: pgsql-admin@postgresql.org Subject: Re: Day Light Savings Problem In-reply-to: <45E737EF.7090709@livedatagroup.com> References: <45E737EF.7090709@livedatagroup.com> Comments: In-reply-to Pallav Kalva message dated "Thu, 01 Mar 2007 15:30:39 -0500" Date: Thu, 01 Mar 2007 15:53:26 -0500 Message-ID: <16652.1172782406@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.06 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_HELO_PASS, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/4 X-Sequence-Number: 24828 Pallav Kalva writes: > postgres@pkalva:/var/lib/pgsql/bin> cd .. > postgres@pkalva:/var/lib/pgsql> cd share > postgres@pkalva:/var/lib/pgsql/share> /usr/sbin/zdump -v EST5EDT | grep 2007 > EST5EDT Sun Apr 1 06:59:59 2007 UTC = Sun Apr 1 01:59:59 2007 EST > isdst=0 gmtoff=-18000 Are you sure that zdump looks into the current directory? The man page is not clear but it says the arguments are "zone names" not "file names", so I'd sort of expect that it's looking into the system timezone directory. In which case this result means that your OS is in need of a timezone update, not Postgres. regards, tom lane