Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BEC562E0064 for ; Wed, 27 Feb 2008 01:21:49 -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 25777-08 for ; Wed, 27 Feb 2008 01:21:47 -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 9D54C2E0048 for ; Wed, 27 Feb 2008 01:21:47 -0400 (AST) Received: from compute1.internal (compute1.internal [10.202.2.41]) by out1.messagingengine.com (Postfix) with ESMTP id D7D08A2261; Wed, 27 Feb 2008 00:21:46 -0500 (EST) Received: from heartbeat1.messagingengine.com ([10.202.2.160]) by compute1.internal (MEProxy); Wed, 27 Feb 2008 00:21:46 -0500 X-Sasl-enc: 8jM//UEDG4fwXQOoiaWEE2J1dZ9n9tm5Q6Bi6vYylRWi 1204089706 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 289E239C9; Wed, 27 Feb 2008 00:21:46 -0500 (EST) Message-ID: <47C4F353.4040304@fastmail.net> Date: Tue, 26 Feb 2008 21:21:23 -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> <47C3E88B.8070803@fastmail.net> <2862.1204040458@sss.pgh.pa.us> <47C4F178.1050102@fastmail.net> <14002.1204089578@sss.pgh.pa.us> In-Reply-To: <14002.1204089578@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/360 X-Sequence-Number: 28434 Tom Lane wrote: > Darren Reed writes: > > Tom Lane wrote: > >> Hm, if you are really lucky, this is because of a corrupt > >> pg_internal.init file. > > > How do I know which files those are? > > find $PGDATA -name pg_internal.init > Doesn't exist. Darren