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 по дате отправления: