Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 924AE9FB6F3 for ; Thu, 1 Mar 2007 17:02:03 -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 15898-08 for ; Thu, 1 Mar 2007 17:01:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mail1.livedatagroup.com (mail1.livedatagroup.com [216.154.205.166]) by postgresql.org (Postfix) with ESMTP id 0A4599FB6D1 for ; Thu, 1 Mar 2007 17:01:49 -0400 (AST) Message-ID: <45E73F25.6070400@livedatagroup.com> Date: Thu, 01 Mar 2007 16:01:25 -0500 From: Pallav Kalva MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: Day Light Savings Problem References: <45E737EF.7090709@livedatagroup.com> <16652.1172782406@sss.pgh.pa.us> In-Reply-To: <16652.1172782406@sss.pgh.pa.us> 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=AWL, BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/5 X-Sequence-Number: 24829 Hi Tom, You are right , I re reran the command now with the whole path it worked. It was looking at the OS time ======================================================================================== postgres@pkalva:/var/lib/pgsql/share/timezone> /usr/sbin/zdump -v /var/lib/pgsql/share/timezone/EST5EDT | grep 2007 /var/lib/pgsql/share/timezone/EST5EDT Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST isdst=0 gmtoff=-18000 /var/lib/pgsql/share/timezone/EST5EDT Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT isdst=1 gmtoff=-14400 /var/lib/pgsql/share/timezone/EST5EDT Sun Nov 4 05:59:59 2007 UTC = Sun Nov 4 01:59:59 2007 EDT isdst=1 gmtoff=-14400 /var/lib/pgsql/share/timezone/EST5EDT Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 EST isdst=0 gmtoff=-18000 ======================================================================================== Thanks! Pallav Tom Lane wrote: > 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 >