Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: could not open relation...No such file or directory
Date
Msg-id 7013.1293037410@sss.pgh.pa.us
Whole thread Raw
In response to Re: could not open relation...No such file or directory  (Sim Zacks <sim@compulab.co.il>)
Responses Re: could not open relation...No such file or directory  (Sim Zacks <sim@compulab.co.il>)
Re: could not open relation...No such file or directory  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: extra TARGETENTRY when group by function( col )?
Next
From: Merlin Moncure
Date:
Subject: Re: libpq sendQuery -- getResult not returning until all queries complete