backing up corrupt database

Поиск
Список
Период
Сортировка
От
Тема backing up corrupt database
Дата
Msg-id 015101c2802c$da3de140$2766f30a@development.greatgulfhomes.com
обсуждение исходный текст
Ответы Re: backing up corrupt database
Re: backing up corrupt database
Список pgsql-general
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?

Thanks

Terry Fielder
Network Engineer
Great Gulf Homes / Ashton Woods Homes
terry@greatgulfhomes.com



В списке pgsql-general по дате отправления: