Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D28F52E3053 for ; Thu, 6 Mar 2008 20:45:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 15830-01 for ; Thu, 6 Mar 2008 20:45:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.internode.com.au (mail.internode.com.au [192.83.231.27]) by postgresql.org (Postfix) with ESMTP id 6D7BE2E01DB for ; Thu, 6 Mar 2008 20:45:47 -0400 (AST) Received: from [172.16.0.221] (staffnet.internode.com.au [203.26.95.65]) by mail.internode.com.au (8.13.7/8.12.1) with ESMTP id m270jjpb017130; Fri, 7 Mar 2008 11:15:45 +1030 (CST) Message-ID: <47D09035.4020005@internode.com.au> Date: Fri, 07 Mar 2008 11:15:41 +1030 From: Shilpa Sudhakar User-Agent: Thunderbird 1.5.0.14 (Windows/20071210) MIME-Version: 1.0 To: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: Time Zone in Postgres References: <2d6659d70803051856x652174a5ic8655d070a95db59@mail.gmail.com> <2d6659d70803052151q5861981aw3a1a2e39e3970704@mail.gmail.com> <19281.1204827832@sss.pgh.pa.us> <47D076B3.8090304@internode.com.au> <20080306234653.GA20591@bunyip.billabong.weebeasite.net> <47D089CE.4040607@internode.com.au> <20080307002740.GK1751@alvh.no-ip.org> <26884.1204850383@sss.pgh.pa.us> In-Reply-To: <26884.1204850383@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.91.2, clamav-milter version 0.91.2 on mail X-Virus-Status: Clean X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/62 X-Sequence-Number: 28545 Hi Tom, If DST changes are done in version 8.2.5 and up, is there any way to recompile the timezone files in our existing versions without upgrading. Thanks Tom Lane wrote: > Alvaro Herrera writes: > >> Shilpa Sudhakar wrote: >> >>> From 2008, the DST ends on first Sunday of April and not on the last Sun >>> of March. >>> > > >> Please report this issue to the guys maintaining the TZ database >> upstream: >> > > You sure they don't know about it already? > > # southeast Australia > # > # From Paul Eggert (2007-07-23): > # Starting autumn 2008 Victoria, NSW, South Australia, Tasmania and the ACT > # end DST the first Sunday in April and start DST the first Sunday in October. > # http://www.theage.com.au/news/national/daylight-savings-to-span-six-months/2007/06/27/1182623966703.html > > This is in our releases 8.2.5 and up. If the OP wants to live under a > government that feels free to whack DST laws around on a couple months' > notice, he's got to be prepared to keep up with software updates. > > regards, tom lane >