Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id DADEE6332C1 for ; Tue, 20 Apr 2010 13:24:48 -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 46169-01-8 for ; Tue, 20 Apr 2010 16:24:28 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og117.obsmtp.com (exprod7og117.obsmtp.com [64.18.2.6]) by mail.postgresql.org (Postfix) with SMTP id A1F446362A6 for ; Tue, 20 Apr 2010 12:53:15 -0300 (ADT) Received: from source ([72.14.220.159]) by exprod7ob117.postini.com ([64.18.6.12]) with SMTP ID DSNKS83N6TqqY2MknVxPMx8TKpAZPTvNGozu@postini.com; Tue, 20 Apr 2010 08:53:15 PDT Received: by fg-out-1718.google.com with SMTP id 22so1827886fge.13 for ; Tue, 20 Apr 2010 08:53:12 -0700 (PDT) MIME-Version: 1.0 Received: by 10.223.123.201 with HTTP; Tue, 20 Apr 2010 08:52:48 -0700 (PDT) In-Reply-To: References: Date: Tue, 20 Apr 2010 11:52:48 -0400 Received: by 10.223.64.194 with SMTP id f2mr930530fai.2.1271778769077; Tue, 20 Apr 2010 08:52:49 -0700 (PDT) Message-ID: Subject: Re: pg_restore -j From: Scott Mead To: Justin Falk Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=001517476474c3888a0484ad1173 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/285 X-Sequence-Number: 34379 --001517476474c3888a0484ad1173 Content-Type: text/plain; charset=ISO-8859-1 On Wed, Apr 14, 2010 at 2:38 AM, Justin Falk wrote: > 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? > I'm pretty sure that you need to use the 8.4 version of pg_dump when you create the backup file, then it should work. --Scott > > Thanks, > > Justin > --001517476474c3888a0484ad1173 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
On Wed, Apr 14, 2010 at 2:38 AM, Justin Falk= <jfalkmu@gmail.c= om> wrote:
Hi,

I'm trying to use the -j option on pg_restore while restorin= g a database into PG 8.4.3.=A0

The dump was executed on PG 8.3.7 (W= indows, 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 spe= cific TOC data block out of order not supported without ID on this input st= ream (fseek required)

The dump works fine if I omit the -j opt= ion.=A0 What am I doing wrong?

I'm pretty sure that you need to use t= he 8.4 version of pg_dump when =A0you create the backup file, then it shoul= d work.

--Scott =A0

Thanks,

Justin

--001517476474c3888a0484ad1173--