Re: could not open relation...No such file or directory - Mailing list pgsql-general

From Adrian Klaver
Subject Re: could not open relation...No such file or directory
Date
Msg-id 4D1232A4.3030109@gmail.com
Whole thread Raw
In response to Re: could not open relation...No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: could not open relation...No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 12/22/2010 09:03 AM, Tom Lane wrote:
> Sim Zacks<sim@compulab.co.il>  writes:
>> Our postgresql database stopped working with the error
>> ERROR: could not open relation 1663/26468499/26470404: No such file or
>> directory
>>> Does the not connect also apply to starting postgres in single user mode?
>> Same error with single user mode.
>> postgres --single -D /var/lib/postgresql/8.2/data clstock
>> FATAL:  could not open relation 1663/26468499/1259: No such file or
>> directory
>
> I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at
> all?
>
>             regards, tom lane
>

Alright I am going to show my ignorance here, but why would it not be?
$PGDATA/base/1663/26468499

--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: could not open relation...No such file or directory
Next
From: Tom Lane
Date:
Subject: Re: could not open relation...No such file or directory