Re: dumping tables from badly damaged db

On Sun, Nov 02, 2003 at 01:45:39PM -0500, Brian Ristuccia wrote:
>
> pg_dump: NOTICE: RelationBuildDesc: can't open deprecated_data1: No such file or directory
> pg_dump: NOTICE: RelationBuildDesc: can't open unimportant_stuff: No such file or directory
> pg_dump: handler procedure for procedural language plpgsql not found
>
> I can't drop the tables from psql:
>
> drop TABLE deprecated_data1 ;
> ERROR: cannot open deprecated_data1: No such file or directory
>

Ok. I managed to drop these in the standalone backend with some hackery:

backend> drop table useless_junk
NOTICE: RelationBuildDesc: can't open useless_junk: No such file or directory
ERROR: cannot open useless_junk: No such file or directory

So I'd have to go select on pg_class and find the relfilenode, go touch that
file so it exists. Try the drop again. Drop any indexes which don't exist.
Find the relfilenode for the associated pg_toast table and go touch that
file too. Not a lot of fun, but the destroyed tables are gone now.

> Am I likely to have success by performing surgery on the pg_table relation
> in order to remove these destroyed tables?

A simple DROP LANGUAGE did the trick.

I can now run pg_dump - I feel much better.

--
Brian Ristuccia