From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Adam Witney <awitney(at)sgul(dot)ac(dot)uk> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: pg_dump error |
Date: | 2005-09-07 15:56:30 |
Message-ID: | 27759.1126108590@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Adam Witney <awitney(at)sgul(dot)ac(dot)uk> writes:
> Got that now.... Sorry but I am being dim... But where do I find the file to
> dump.. You want the index on pg_toast_134401982 right?
Right (if that's the toast table you identified for the problem table).
It's probably named pg_toast_134401982_index. Look at its pg_class
entry to find its relfilenode number, and find the OID of the database
from pg_database, and then the file should be
$PGDATA/base/DBOID/RELFILENODE. For more info see
http://www.postgresql.org/docs/8.0/static/storage.html
(which is for 8.0, but everything except the remarks about tablespaces
applies to 7.4).
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-07 17:06:26 | Re: pg_dump error... Follow up |
Previous Message | Adam Witney | 2005-09-07 15:40:22 | Re: pg_dump error |