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?
