Re: parallel option in pg_restore

> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Tuesday, June 22, 2010 10:37 AM
> To: Igor Neyman
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] parallel option in pg_restore
>
> "Igor Neyman" <ineyman(at)perceptron(dot)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.

Regards,
Igor Neyman