Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6E7BD64FCC0 for ; Tue, 26 Aug 2008 10:10:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81205-06 for ; Tue, 26 Aug 2008 10:10:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from lists.commandprompt.com (host-159.commandprompt.net [207.173.203.159]) by postgresql.org (Postfix) with ESMTP id 2EABE6501B7 for ; Tue, 26 Aug 2008 10:10:30 -0300 (ADT) Received: from commandprompt.com (CPE001b63afe888-CM001adea9c5a6.cpe.net.cable.rogers.com [99.236.211.160]) (authenticated bits=0) by lists.commandprompt.com (8.13.8/8.13.8) with ESMTP id m7QDDTbr018710 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 26 Aug 2008 06:13:32 -0700 Date: Tue, 26 Aug 2008 09:10:24 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Bug introduced in 8.0 Message-ID: <20080826131023.GJ10936@commandprompt.com> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <15aa6b3e0808260421r1b97b7dfoa53fd6f04ffbd49b@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <15aa6b3e0808260421r1b97b7dfoa53fd6f04ffbd49b@mail.gmail.com> User-Agent: Mutt/1.5.17 (2007-11-01) X-Greylist: Sender succeeded SMTP AUTH, not delayed by milter-greylist-4.0 (lists.commandprompt.com [207.173.203.159]); Tue, 26 Aug 2008 06:13:33 -0700 (PDT) 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: 200808/164 X-Sequence-Number: 30009 On Tue, Aug 26, 2008 at 08:21:53AM -0300, Sergio Gabriel Rodriguez wrote: > "Fix bug introduced in 8.0 that could allow ReadBuffer to return an > already-used page as new, potentially causing loss of > recently-committed data (Tom)" > http://www.postgresql.org/docs/8.0/static/release-8-0-6.html > > I know an upgrade is a best solution but it's impossible now for me (I > do not have authorization), my answer is, what exactly means this bug? > is serious? Yes, it's serious. It means that you can lose data that has been committed. Get authorization. You can install the latest version of the 8.0.x software directly in place, with no dump or restore. It's a drop-in replacement. The minor releases are security and stability releases. If your management thinks that they are optional to install, then get that in writing, because they are instructing you to run known-dangerous software. They are being negligent. Patching your software for known defects is not "upgrading", it's "doing your job." A -- Andrew Sullivan ajs@commandprompt.com +1 503 667 4564 x104 http://www.commandprompt.com/