Re: backing up corrupt database

On Wednesday 30 Oct 2002 3:56 pm, terry@ashtonwoodshomes.com wrote:
> My first post didn't work, so here goes again
>
> I want to backup my database, which appears to be corrupt.  The projects
> table is corrupt:
> bash$ pg_dump devtest2
> pg_dump: Attempt to lock table "projects" failed.  ERROR:  cannot find
> attribute
>  8 of relation projects
>
> When I try to drop this corrupted table:
> devtest2=# drop table projects;
> ERROR:  cannot find attribute 8 of relation projects
>
> How can I manually purge this table from the system tables so that I can
> run a backup and then recreate the database?

Well, pg_class contains the tables - relname holds the name. I've just tried
deleting a table from it and using pg_dump and it seemed to work.

Having said that, I'd be tempted to pg_dump all the other tables individually
and then give it a go - I'm always a little uneasy about tinkering with the
system tables even when the developers say it should be fine.

--
  Richard Huxton