failures in pg_restore -- possibly corrupt archive

From: AccessDevelopment TEST <caleb(dot)access(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: failures in pg_restore -- possibly corrupt archive
Date: 2014-01-02 22:03:23
Message-ID: CADiaVNkaZfHDtva=4bdScqwPUE4azsUL6mo=3biUfokz1YC9wg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I am attempting to restore a pg dump file and am getting this error message:

pg_restore: [custom archiver] could not find block ID 229750 in archive
-- possibly corrupt archive
pg_restore: [custom archiver] could not find block ID 228874 in archive
-- possibly corrupt archive
pg_restore: [archiver] worker process failed: exit code 1

The pg_restore command used is:
pg_restore -j 12 -d mydb -h myhost -U username /restore/file.dump

pg_dump was used to created the backup.

I have searched around and have found no information that would lead to a
remedy for a successful restore. We have analyzed the disk for bad blocks
and could find no problem there. There is no additional information
provided than the messages listed above.

Any ideas?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2014-01-02 22:31:40 Re: failures in pg_restore -- possibly corrupt archive
Previous Message Kido Kouassi 2014-01-02 17:13:50 Re: PostgreSQL 9.3 PITR from remote server failing