Please help (backup)
От | Anibal David Acosta |
---|---|
Тема | Please help (backup) |
Дата | |
Msg-id | 471BF9DB.2010301@personal.net.py обсуждение исходный текст |
Ответ на | Re: Trigger AFTER UPDATE OR INSERT ("Scott Marlowe" <scott.marlowe@gmail.com>) |
Ответы |
Re: Please help (backup)
|
Список | pgsql-admin |
I have a backup done with "pg_dump" utility. For some reason the backup file has 8 phisical bad sectors (17 KB of data) Now when I try to restore the backup all tables are created successfully and data of almost all tables restores successfully too, but one table (the most important) appear empty. When I do a pg_restore <backup_file> its show all sql instructions and data until arrive to the "damaged sector" and throws a "out of memory" exception. I want to know if is possible to fix the backup file removing the blocks in the "bad sectors" in order to restore all other information. something like file dump surgery :) Thanks! Anibal
В списке pgsql-admin по дате отправления: