Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 43CC4686A5D for ; Tue, 22 Jun 2010 11:37:22 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 58625-07 for ; Tue, 22 Jun 2010 14:37:12 +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 BD4AD687250 for ; Tue, 22 Jun 2010 11:37:14 -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 o5MEb2if001321; Tue, 22 Jun 2010 10:37:03 -0400 (EDT) To: "Igor Neyman" cc: pgsql-admin@postgresql.org Subject: Re: parallel option in pg_restore In-reply-to: References: Comments: In-reply-to "Igor Neyman" message dated "Tue, 22 Jun 2010 09:31:10 -0400" Date: Tue, 22 Jun 2010 10:37:02 -0400 Message-ID: <1319.1277217422@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: 201006/154 X-Sequence-Number: 34932 "Igor Neyman" writes: > I'm testing 8.4.4 (on Windows) before upgrading our app to this PG > version. > When running pg_restore with "-j 2" parallel option, I'm getting the > following error: > "pg_restore: [custom archiver] dumping a specific TOC data block out of > order is not supported without ID on this input stream (fseek required)" We have gotten several reports of this, but none of the developers have been able to reproduce it. Can you provide an exact test case? regards, tom lane