Need Help Restoring Old Backup

Поиск
Список
Период
Сортировка
Искать
От
Steve Knott
Тема
Need Help Restoring Old Backup
Дата
Msg-id
52ADFC50.3090507@ttonk.com
Список
Дерево обсуждения
Need Help Restoring Old Backup Steve Knott <steve@ttonk.com>
Re: Need Help Restoring Old Backup Adrian Klaver <adrian.klaver@gmail.com>
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 по дате отправления
От: Wolfgang Keller
Дата:
От: Juan Pablo L
Дата:
FAQ