| From: | Steve Knott <steve(at)ttonk(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Need Help Restoring Old Backup |
| Date: | 2013-12-15 19:00:32 |
| Message-ID: | 52ADFC50.3090507@ttonk.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dbaston | 2013-12-15 20:18:40 | SELECT from record-returning function causes function code to be executed multiple times |
| Previous Message | Christofer C. Bell | 2013-12-15 16:34:19 | Re: [DOCS] Re: postgresql.org inconsistent (Re: PG replication across DataCenters) |