From: Glyn Astill <glynastill@yahoo.co.uk>
To: Tom Lane <tgl@sss.pgh.pa.us>
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: parallel option in pg_restore
Date: Tue, 22 Jun 2010 15:26:34 +0000 (GMT)
Message-ID: <412620.30094.qm@web23607.mail.ird.yahoo.com> (raw)
In-Reply-To: <F4C27E77F7A33E4CA98C19A9DC6722A206251F9A@EXCHANGE.corp.perceptron.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: glynastill@yahoo.co.uk, tgl@sss.pgh.pa.us, ineyman@perceptron.com
Subject: Re: parallel option in pg_restore
In-Reply-To: <412620.30094.qm@web23607.mail.ird.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox