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