Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 564C42E006C for ; Thu, 17 Apr 2008 07:36:16 -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 28173-09 for ; Thu, 17 Apr 2008 07:36:09 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from yw-out-2324.google.com (yw-out-2324.google.com [74.125.46.28]) by developer.postgresql.org (Postfix) with ESMTP id DE6A22E0037 for ; Thu, 17 Apr 2008 07:36:08 -0300 (ADT) Received: by yw-out-2324.google.com with SMTP id 2so2899ywt.73 for ; Thu, 17 Apr 2008 03:36:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=HnbCKo+Cx4Hi7C/Y6fWS12sQAC0yiQsTvLGYXMHMCxI=; b=dgw7Mfd8MTU6zH3R6PjjBcY+Azic1BF6IzOyCse+cjWg1l7FZz+rmeY4MWoakKWCnwOSoR1sRCMpQNpZEX0LkKi+jKsaPIFtB2C3DXQ1SpeeK0PpkYJ7vv/EDr6X20kAFX18p2+9n7qLbLnZFCqVPDFledmm5zs9UqjmFKYUkbM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Ktz3ZJQW1fjLTNA5zJCk9335OlTCcFSnySsJB7CtcqnuH2GV1yBhph2YQgv3cqwAWwbf7thIvFzFCcfMUgT4igzKV9kE9cWze45fr7un745lDOQ8NBIoN2GgbLiSAwYN5D5dASIt/SNQ4yTN+DBFo64KLLinagHYdlrxy8P7tOE= Received: by 10.151.14.5 with SMTP id r5mr1384236ybi.210.1208428560053; Thu, 17 Apr 2008 03:36:00 -0700 (PDT) Received: by 10.150.97.21 with HTTP; Thu, 17 Apr 2008 03:36:00 -0700 (PDT) Message-ID: <2e78013d0804170336j4299161bm3f280fc9b930b474@mail.gmail.com> Date: Thu, 17 Apr 2008 16:06:00 +0530 From: "Pavan Deolasee" To: "Mikko Partio" Subject: Re: FATAL: could not open relation xxx: No such file or directory Cc: pgsql-admin@postgresql.org In-Reply-To: <2ca799770804170308m367eaea2nc7899198c0b260e0@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <2ca799770804090647m759b72f9gf2d49b4bf7cc8bdf@mail.gmail.com> <2ca799770804142336q6422af38me80054c82699d1e2@mail.gmail.com> <2ca799770804170308m367eaea2nc7899198c0b260e0@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/169 X-Sequence-Number: 28933 On Thu, Apr 17, 2008 at 3:38 PM, Mikko Partio wrote: > > 2008-04-17 13:05:30 EEST [8435]: [32-1] ERROR: could not open relation > 1663/16386/359232: No such file or directory > Looks like a corrupt index to me. DId you try REINDEX on the table ? Thanks, Pavan -- Pavan Deolasee EnterpriseDB http://www.enterprisedb.com