Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 12260633E4C for ; Tue, 20 Apr 2010 13:20:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96146-02-4 for ; Tue, 20 Apr 2010 16:20:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id E00CD6358F1 for ; Tue, 20 Apr 2010 12:32:22 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o3KFWI2C012662; Tue, 20 Apr 2010 11:32:18 -0400 (EDT) To: Justin Falk cc: pgsql-admin@postgresql.org Subject: Re: pg_restore -j In-reply-to: References: Comments: In-reply-to Justin Falk message dated "Wed, 14 Apr 2010 01:38:09 -0500" Date: Tue, 20 Apr 2010 11:32:18 -0400 Message-ID: <12661.1271777538@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201004/283 X-Sequence-Number: 34377 Justin Falk writes: > When I try to restore I'm using: > pg_restore -d mydb -U postgres -j 4 mydb.backup > This results in an error: > pg_restore: [custom archiver] dumping a specific TOC data block out of order > not supported without ID on this input stream (fseek required) There was something similar reported here: http://archives.postgresql.org/pgsql-admin/2010-04/msg00237.php but we haven't got to the bottom of it yet. Can you create a self-contained test case? regards, tom lane