Need Help Restoring Old Backup
От | Steve Knott |
---|---|
Тема | Need Help Restoring Old Backup |
Дата | |
Msg-id | 52ADFC50.3090507@ttonk.com обсуждение исходный текст |
Ответы |
Re: Need Help Restoring Old Backup
|
Список | pgsql-general |
Hi, I have a really old database (5+ years old) that was backed up stored away for a while. Now I want some data out of it. I originally thought that if I made a backup and kept around the original database install.exe file, I could reinstall the db & restore the data. It looks like that is not happening. The old database was somewhere in 8.2.x before it was shut down. Whenever I try to restore, I get: > pg_restore: [archiver (db)] Error while PROCESSING TOC: > pg_restore: [archiver (db)] Error from TOC entry 1490: 1259 26787 TABLE users client > ... > pg_restore: [custom archiver] found unexpected block ID (1257691431) when reading data -- expected 2049 I tried restoring on an 8.2, 8.4 and 9.0, but each fail with similar error messages. Is there anyway to repair this file or break it up some I can get most of the data out of it? It appears to be stopping half way through. If I could get it past this point, I could at least reclaim the tables after this issue. Thanks for any help, Steve
В списке pgsql-general по дате отправления: