Re: could not open relation...No such file or directory

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: Sim Zacks <sim(at)compulab(dot)co(dot)il>, PostgreSQL general <pgsql-general(at)postgresql(dot)org>
Subject: Re: could not open relation...No such file or directory
Date: 2010-12-22 18:41:31
Message-ID: 8217.1293043291@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2010-12-22 19:01:06 Re: How to use pgbouncer
Previous Message Sim Zacks 2010-12-22 17:56:45 Re: could not open relation...No such file or directory