Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id AABE82E0030 for ; Tue, 26 Feb 2008 03:00:20 -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 04824-09 for ; Tue, 26 Feb 2008 03:00:17 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from out3.smtp.messagingengine.com (out3.smtp.messagingengine.com [66.111.4.27]) by postgresql.org (Postfix) with ESMTP id E727A2E0039 for ; Tue, 26 Feb 2008 03:00:17 -0400 (AST) Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id 845D2A1221; Tue, 26 Feb 2008 02:00:16 -0500 (EST) Received: from heartbeat2.messagingengine.com ([10.202.2.161]) by compute1.internal (MEProxy); Tue, 26 Feb 2008 02:00:16 -0500 X-Sasl-enc: gitzzJfarMTQ93HpNhbxzHfRmpIrB6deG0LKhuFicgmd 1204009216 Received: from [192.168.1.235] (76-191-150-176.dsl.dynamic.sonic.net [76.191.150.176]) by mail.messagingengine.com (Postfix) with ESMTPSA id A14E224FA1; Tue, 26 Feb 2008 02:00:15 -0500 (EST) Message-ID: <47C3B8EC.902@fastmail.net> Date: Mon, 25 Feb 2008 22:59:56 -0800 From: Darren Reed User-Agent: Thunderbird 2.0.0.0 (Windows/20070326) MIME-Version: 1.0 To: Tom Lane CC: Shoaib Mir , pgsql-admin@postgresql.org Subject: Re: How to reindex when unable to open relation? References: <47C3AE1F.2010804@fastmail.net> <26104.1204008849@sss.pgh.pa.us> In-Reply-To: <26104.1204008849@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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: 200802/337 X-Sequence-Number: 28411 Tom Lane wrote: > ... > There's no info here to suggest exactly what went wrong; Darren, do you > want to fess up to any hardware problems, tripped-over power cords, or > such? What PG version is this anyway? > This is 8.2.6... and I'm starting to believe the hardware is just borked, with all of the other troubles I've had. In an earlier bringup of the database, I received an error intended for Linux kernels on a BSD box about a page not being zero... Darren