Skip site navigation (1) Skip section navigation (2)

Re: pg_restore -j

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Justin Falk <jfalkmu(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_restore -j
Date: 2010-04-20 15:32:18
Message-ID: 12661.1271777538@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Justin Falk <jfalkmu(at)gmail(dot)com> writes:
> 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)

There was something similar reported here:
http://archives.postgresql.org/pgsql-admin/2010-04/msg00237.php
but we haven't got to the bottom of it yet.  Can you create a
self-contained test case?

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Jeffrey GaynorDate: 2010-04-20 15:40:01
Subject: Re: SSL question
Previous:From: Tom LaneDate: 2010-04-20 15:28:53
Subject: Re: drop database / create database / data still here ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group