Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 512BC9F9B13 for ; Wed, 19 Sep 2007 21:51:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 38895-02 for ; Wed, 19 Sep 2007 21:51:21 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 9F7109F9A3A for ; Wed, 19 Sep 2007 21:51:26 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so344860ugf for ; Wed, 19 Sep 2007 17:51:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=xILDHlExh/Qky4Y2955OsqHLSc0BzJT5Sg3botb4II8=; b=rAv45XoWnilHBu3y+n/ywVXBatOF6C0eYJifFLiSJLU67AyxzBCL4hHlLwEEFcc62NBDvlGv/AZtJ0g8Bb3fA9nb+DCc/x9kgdh32JXmCONPK78NcmKGzbPdARSgNhjxgmJPDoG5UOaiSgOgF8qwWOOt6ufNcREOrff/duswkx8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=aTNnyWQgxRrNPSAinaNSjHt8apNEu+Ess5TvKBq+nRIPQVTeBo2hbkxP5J7ifn3OTSZ+dTBdGRpGYTDqc+CyjQ90kVvML/RTuLKwVXDKWossCpbjmQjQXplDxSLbvEdjO7ERe6gXf7ocdm78ENGs/Gq9X14WHVj+7ckRmTyDg+s= Received: by 10.66.221.5 with SMTP id t5mr2533905ugg.1190249484961; Wed, 19 Sep 2007 17:51:24 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Wed, 19 Sep 2007 17:51:24 -0700 (PDT) Message-ID: Date: Wed, 19 Sep 2007 19:51:24 -0500 From: "Scott Marlowe" To: adey Subject: Re: Daylight Savings Updates Cc: postgresql-l , postgresql In-Reply-To: <1c66bda80709191644l5ad70ec8k266ed84824870b03@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1c66bda80709191644l5ad70ec8k266ed84824870b03@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/119 X-Sequence-Number: 26880 On 9/19/07, adey wrote: > Hi, > Please advise whether it is necessary for us to apply a later version of > Postgres in preparation for the new daylight savings times coming in to > effect in New Zealand at the end of September? > We are running PG 8.1.4 and 8.1.6. > FAQ's indicate that our one remaining system on 7.1.4 will use the operating > system daylight savings settings, but do we have to apply anything to our > 8.1 systems, why, and what is involved in doing so please? > Adrian Yes, you need to update to 8.1.10 to get those changes. Starting with 8.0 or 8.1, postgresql began including its own timezone data.