Skip site navigation (1) Skip section navigation (2)

Re: FATAL: could not open relation xxx: No such file or directory

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: "Mikko Partio" <mpartio(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Date: 2008-04-17 10:36:00
Message-ID: 2e78013d0804170336j4299161bm3f280fc9b930b474@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, Apr 17, 2008 at 3:38 PM, Mikko Partio <mpartio(at)gmail(dot)com> 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

In response to

Responses

pgsql-admin by date

Next:From: Mikko PartioDate: 2008-04-17 10:44:22
Subject: Re: FATAL: could not open relation xxx: No such file or directory
Previous:From: Mikko PartioDate: 2008-04-17 10:08:58
Subject: Re: FATAL: could not open relation xxx: No such file or directory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group