Adam Witney <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
