Re: failures in pg_restore -- possibly corrupt archive - Mailing list pgsql-admin

From Tom Lane
Subject Re: failures in pg_restore -- possibly corrupt archive
Date
Msg-id 18119.1388701900@sss.pgh.pa.us
Whole thread Raw
In response to failures in pg_restore -- possibly corrupt archive  (AccessDevelopment TEST <caleb.access@gmail.com>)
Responses Re: failures in pg_restore -- possibly corrupt archive
List pgsql-admin
AccessDevelopment TEST <caleb.access@gmail.com> writes:
> 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

This looks suspiciously like some old complaints about unsupported cases
in parallel restore.  Does it work if you omit the -j option?  If so,
what versions of pg_dump and pg_restore are you using exactly, and what
did the pg_dump command look like?

            regards, tom lane


pgsql-admin by date:

Previous
From: AccessDevelopment TEST
Date:
Subject: failures in pg_restore -- possibly corrupt archive
Next
From: Caleb Access
Date:
Subject: failures in pg_restore -- possibly corrupt archive