Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vyqnp-0002lD-2a for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jan 2014 22:31:45 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vyqno-0005iK-J1 for pgsql-admin@arkaria.postgresql.org; Thu, 02 Jan 2014 22:31:44 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vyqnn-0005iD-FB for pgsql-admin@postgresql.org; Thu, 02 Jan 2014 22:31:43 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vyqnl-0007l5-Cp for pgsql-admin@postgresql.org; Thu, 02 Jan 2014 22:31:42 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id s02MVeGp018120; Thu, 2 Jan 2014 17:31:40 -0500 From: Tom Lane To: AccessDevelopment TEST cc: pgsql-admin@postgresql.org Subject: Re: failures in pg_restore -- possibly corrupt archive In-reply-to: References: Comments: In-reply-to AccessDevelopment TEST message dated "Thu, 02 Jan 2014 15:03:23 -0700" Date: Thu, 02 Jan 2014 17:31:40 -0500 Message-ID: <18119.1388701900@sss.pgh.pa.us> X-Pg-Spam-Score: -2.4 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org AccessDevelopment TEST 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin