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