DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=NZDLjs0NBA8rEQMZPfUfW6BIEeAeFAACiPs9CBNVqCsiROZfTRrfo52ZP4/fKMPlSP2mcRe2yj1ZzLWHE3UPsTW3H+1wRnCyRrmlKs03bfr7ndUgBoYL/ACqvSGyGfnwQ1awQGeCX13oAY7xWAZ6iE+0sLQtuEmOXEZ/RNdnpnY=;
Message-ID: <412620.30094.qm@web23607.mail.ird.yahoo.com>
Date: Tue, 22 Jun 2010 15:26:34 +0000 (GMT)
From: Glyn Astill <glynastill@yahoo.co.uk>
Subject: Re: parallel option in pg_restore
To: Tom Lane <tgl@sss.pgh.pa.us>, Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-admin@postgresql.org
In-Reply-To: 
 <F4C27E77F7A33E4CA98C19A9DC6722A206251F9A@EXCHANGE.corp.perceptron.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

> From: Igor Neyman <ineyman@perceptron.com>=0A> Subject: Re: [ADMIN] paral=
lel option in pg_restore=0A> To: "Tom Lane" <tgl@sss.pgh.pa.us>=0A> Cc: pgs=
ql-admin@postgresql.org=0A> Date: Tuesday, 22 June, 2010, 16:05=0A> > -----=
Original Message-----=0A> > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=0A> =
=0A> > Sent: Tuesday, June 22, 2010 10:37 AM=0A> > To: Igor Neyman=0A> > Cc=
: pgsql-admin@postgresql.org=0A> > Subject: Re: [ADMIN] parallel option in =
pg_restore =0A> > =0A> > "Igor Neyman" <ineyman@perceptron.com>=0A> writes:=
=0A> > > I'm testing 8.4.4 (on Windows) before upgrading=0A> our app to thi=
s PG =0A> > > version.=0A> > > When running pg_restore with "-j 2" parallel=
=0A> option, I'm =0A> > getting the =0A> > > following error:=0A> > > "pg_r=
estore: [custom archiver] dumping a specific=0A> TOC data =0A> > block out =
=0A> > > of order is not supported without ID on this=0A> input stream =0A>=
 > (fseek required)"=0A> > =0A> > We have gotten several reports of this, b=
ut none of=0A> the =0A> > developers have been able to reproduce it.=A0 Can=
=0A> you provide =0A> > an exact test case?=0A> > =0A> > =A0=A0=A0 =A0=A0=
=A0=0A> =A0=A0=A0 regards, tom lane=0A> > =0A> > =0A> =0A> Tom,=0A> =0A> Ba=
ckup files I'm trying to restore "in parallel" contain=0A> partitions of=0A=
> several partitioned tables.=0A> Tables partitioned "by month", each backu=
p file contains 1=0A> month worth=0A> of data for all partitioned tables.=
=0A> =0A> Before restoring backed up partitions, I'm restoring from=0A> ano=
ther backup=0A> file (not using "-j"), which contains "base" (empty)=0A> ta=
bles, from which=0A> partitions inherited. And this restore runs fine.=0A> =
=0A> Is that the information you asked for, or you want a sample=0A> of sma=
ll=0A> backup file attached?=0A> I'm attaching pg_restore log file, if it's=
 of any help.=0A> =0A=0AIn my experiments the error went away when I reduce=
d the amount of data in the tables being restored/size of the dump.=0A=0ATh=
is is as far as I got, but I let it rest for a while due to lack of respons=
e on the list.=0A=0Ahttp://archives.postgresql.org/pgsql-general/2010-05/ms=
g00778.php=0A=0A=0A=0A=0A