Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 03DD163252A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 14 Apr 2010 03:38:22 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 25991-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed, 14 Apr 2010 06:38:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iw0-f187.google.com (mail-iw0-f187.google.com
	[209.85.223.187])
	by mail.postgresql.org (Postfix) with ESMTP id 1562C6324A1
	for <pgsql-admin@postgresql.org>; Wed, 14 Apr 2010 03:38:10 -0300 (ADT)
Received: by iwn17 with SMTP id 17so3703576iwn.19
	for <pgsql-admin@postgresql.org>; Tue, 13 Apr 2010 23:38:09 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:received:message-id
	:subject:from:to:content-type;
	bh=OOSNCmDciuSnFnp0DqQwX3BN/tTKaPwgaJ1B6PPaOdI=;
	b=xAdzUgKVd14mvzDIjAbREe9kTS26iaEJjZSgk4HOstuX8guoOnzBhDRqPlGmxbRJfo
	i1/z8Bs6+OvTh/Ul607/lKPtt4mYlNn6841486S/yBULWsE4KiprlVUsC8xRdRx9bY9g
	TvvrxLU5kLFxNbhpZMNKkQrLYMBtn+EtZfOa4=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=kSVA8oPKMMvDwgkR5lDT1WjrJ7sE0X57ESg1bsLI66INp5urxDl1bxFG0rTgOU3QFe
	2TVD2y206/8YtvKBkxn/Rtkl8ncpAe1xODMe3+SHMSxwyUqXA+bLIx4ztu6Fz27pLfR2
	Kz4vuVsJFCZcIihObYB5U1K5RZr3D2XgLE3Jc=
MIME-Version: 1.0
Received: by 10.231.199.135 with HTTP; Tue, 13 Apr 2010 23:38:09 -0700 (PDT)
Date: Wed, 14 Apr 2010 01:38:09 -0500
Received: by 10.231.160.195 with SMTP id o3mr3136794ibx.32.1271227089867;
 Tue,
	13 Apr 2010 23:38:09 -0700 (PDT)
Message-ID: <w2h594c267d1004132338k8aafd351p59eb46a06ceee206@mail.gmail.com>
Subject: pg_restore -j
From: Justin Falk <jfalkmu@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=0050450163d51ed5c604842c9f97
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201004/278
X-Sequence-Number: 34372

--0050450163d51ed5c604842c9f97
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I'm trying to use the -j option on pg_restore while restoring a database
into PG 8.4.3.

The dump was executed on PG 8.3.7 (Windows, Server 2003) using:

pg_dump -Fc -U postgres mydb > mydb.backup

This results in a ~3.4 GB dump file.

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)

The dump works fine if I omit the -j option.  What am I doing wrong?

Thanks,

Justin

--0050450163d51ed5c604842c9f97
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,<br><br>I&#39;m trying to use the -j option on pg_restore while restorin=
g a database into PG 8.4.3.=A0 <br><br>The dump was executed on PG 8.3.7 (W=
indows, Server 2003) using:<br><br><div style=3D"margin-left: 40px;">pg_dum=
p -Fc -U postgres mydb &gt; mydb.backup<br>
</div><br>This results in a ~3.4 GB dump file.<br><br>When I try to restore=
 I&#39;m using:<br><br><div style=3D"margin-left: 40px;">pg_restore -d mydb=
 -U postgres -j 4 mydb.backup<br></div><br>This results in an error:<br><br=
>
<div style=3D"margin-left: 40px;">pg_restore: [custom archiver] dumping a s=
pecific TOC data block out of order not supported without ID on this input =
stream (fseek required)<br></div><br>The dump works fine if I omit the -j o=
ption.=A0 What am I doing wrong?<br>
<br>Thanks,<br><br>Justin<br>

--0050450163d51ed5c604842c9f97--