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

On 12/22/2010 10:41 AM, Tom Lane wrote:
> Adrian Klaver<adrian.klaver@gmail.com>  writes:
>> On 12/22/2010 09:03 AM, Tom Lane wrote:
>>> I begin to wonder if the subdirectory $PGDATA/base/26468499 is there at
>>> all?
>
>> Alright I am going to show my ignorance here, but why would it not be?
>> $PGDATA/base/1663/26468499
>
> 1663 is the pg_default tablespace, which refers to $PGDATA/base
> (hardwired knowledge in the file-path-construction code).  See
> http://developer.postgresql.org/pgdocs/postgres/storage-file-layout.html
>
>             regards, tom lane

<Slap forehead> Remember tablespaces. Thanks.

--
Adrian Klaver
adrian.klaver@gmail.com