Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id C52FF2E003E for ; Sat, 26 Apr 2008 16:55:31 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 55497-03 for ; Sat, 26 Apr 2008 16:55:28 -0300 (ADT) X-Greylist: delayed 00:21:26.578757 by SQLgrey-1.7.5 Received: from smtp.goodstockimages.com (c-75-72-198-120.hsd1.mn.comcast.net [75.72.198.120]) by developer.postgresql.org (Postfix) with ESMTP id 1A0F42E005C for ; Sat, 26 Apr 2008 16:55:27 -0300 (ADT) Received: from [192.168.1.103] (unknown [192.168.1.103]) by smtp.goodstockimages.com (Postfix) with ESMTP id BEFDE83C31B for ; Sat, 26 Apr 2008 14:34:01 -0500 (CDT) Message-ID: <481383A7.5060804@comcast.net> Date: Sat, 26 Apr 2008 14:33:59 -0500 From: MC Moisei User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: org.postgresql.util.PSQLException: 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=2.224 tagged_above=0 required=5 tests=RCVD_IN_PBL=0.509, RCVD_IN_SORBS_DUL=1.615, RDNS_DYNAMIC=0.1 X-Spam-Level: ** X-Archive-Number: 200804/265 X-Sequence-Number: 29029 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