Re: pg_restore -j - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: pg_restore -j
Date
Msg-id 201004201526.o3KFQLg20703@momjian.us
Whole thread Raw
In response to pg_restore -j  (Justin Falk <jfalkmu@gmail.com>)
List pgsql-admin
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?

Perhaps this is fixed in 8.3.10.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: drop database / create database / data still here ?
Next
From: Tom Lane
Date:
Subject: Re: drop database / create database / data still here ?