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: | Raw Message | Whole Thread | 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) |