Received: from localhost (unknown [200.46.204.184]) by developer.postgresql.org (Postfix) with ESMTP id 1A7642E005C for ; Sat, 26 Apr 2008 01:19:40 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 80576-06 for ; Sat, 26 Apr 2008 01:19:30 -0300 (ADT) X-Greylist: delayed 00:05:32.971138 by SQLgrey-1.7.5 Received: from QMTA04.emeryville.ca.mail.comcast.net (qmta04.emeryville.ca.mail.comcast.net [76.96.30.40]) by developer.postgresql.org (Postfix) with ESMTP id 5E8BD2E0032 for ; Sat, 26 Apr 2008 01:19:30 -0300 (ADT) Received: from OMTA07.emeryville.ca.mail.comcast.net ([76.96.30.59]) by QMTA04.emeryville.ca.mail.comcast.net with comcast id J2jd1Z00C1GXsucA406Q00; Sat, 26 Apr 2008 04:12:11 +0000 Received: from [192.168.1.103] ([75.72.198.120]) by OMTA07.emeryville.ca.mail.comcast.net with comcast id J4Du1Z0082cLq9F8T00000; Sat, 26 Apr 2008 04:13:55 +0000 X-Authority-Analysis: v=1.0 c=1 a=Rr1ETXF3pDubFo5mvrMA:9 a=0oWdJ16hho8estJ7CtR9xo-xh_wA:4 a=gi0PWCVxevcA:10 Message-ID: <4812AC03.3000803@gmail.com> Date: Fri, 25 Apr 2008 23:13:55 -0500 From: Q Master User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: ERROR: could not open relation 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: 200804/259 X-Sequence-Number: 29023 I get this strange error Caused by: org.postgresql.util.PSQLException: ERROR: could not open relation 1663/53544/58374: No such file or directory How do I recover from it ? Version 8.2 on windows. I think I had an hardware issue in the past where my box rebooted few times I assume this is due to that thing. I tried to re index them but is not working. Any ideas ? Thanks Q