From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | terry(at)ashtonwoodshomes(dot)com |
Cc: | "Postgres (E-mail)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: backing up corrupt database |
Date: | 2002-10-30 19:12:38 |
Message-ID: | 699.1036005158@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
<terry(at)ashtonwoodshomes(dot)com> writes:
> When I try to drop this corrupted table:
> devtest2=# drop table projects;
> ERROR: cannot find attribute 8 of relation projects
Sounds like a mess. What PG version is this? Do you know what happened
to cause the corruption?
> How can I manually purge this table from the system tables so that I can run
> a backup and then recreate the database?
If you do not care about this table, then "DELETE FROM pg_class WHERE
relname = 'projects'" would do it.
If you do care, I'd try a system-table reindex (read the REINDEX man
page carefully) before giving up on it. The problem is probably just
corruption in one of the indexes on pg_attribute.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2002-10-30 20:03:21 | Re: What user to defaults execute as? |
Previous Message | Richard Huxton | 2002-10-30 19:10:00 | Re: permission prob: granted, but still denied |