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 8217.1293043291@sss.pgh.pa.us
Whole thread Raw
In response to Re: could not open relation...No such file or directory  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: could not open relation...No such file or directory  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: Re: could not open relation...No such file or directory
Next
From: Andreas Kretschmer
Date:
Subject: Re: How to use pgbouncer