Need Help Restoring Old Backup

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

Responses

Browse pgsql-general by date

  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)