| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 19:31:16 |
| Message-ID: | 4D125204.7080808@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 12/22/2010 10:41 AM, Tom Lane wrote:
> 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
<Slap forehead> Remember tablespaces. Thanks.
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leif Biberg Kristensen | 2010-12-22 19:39:48 | Re: Root user commands |
| Previous Message | Brar Piening | 2010-12-22 19:18:09 | Re: "could not accept SSPI security context" |