Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore -j - Mailing list pgsql-admin

From Scott Mead
Subject Re: pg_restore -j
Date
Msg-id h2td3ab2ec81004200852rb2c67ab5s9720c46f20d3bca7@mail.gmail.com
Whole thread Raw
In response to pg_restore -j  (Justin Falk <jfalkmu@gmail.com>)
Responses Re: pg_restore -j  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

On Wed, Apr 14, 2010 at 2:38 AM, Justin Falk <jfalkmu@gmail.com> 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

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: drop database / create database / data still here ?
Next
From: "Kevin Grittner"
Date:
Subject: Re: pg_restore -j