From: John Rouillard <rouilj@renesys.com>
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: parallel option in pg_restore
Date: Tue, 22 Jun 2010 15:51:49 +0000
Message-ID: <20100622155149.GO703@renesys.com> (raw)
In-Reply-To: <F4C27E77F7A33E4CA98C19A9DC6722A206251F9A@EXCHANGE.corp.perceptron.com>
References: <F4C27E77F7A33E4CA98C19A9DC6722A206251EB8@EXCHANGE.corp.perceptron.com>
<1319.1277217422@sss.pgh.pa.us>
<F4C27E77F7A33E4CA98C19A9DC6722A206251F9A@EXCHANGE.corp.perceptron.com>
On Tue, Jun 22, 2010 at 11:05:02AM -0400, Igor Neyman wrote:
> > "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
> 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.
I realise this may be a silly question (especially for windows), but
the fseek complaint has me wondering.
Are you running a pipleine reatore? E.G:
type dumpfile | pg_restore -j 2
or are you running:
pg_restore -j 2 dumpfile
in the latter case it should be fseekable, but in the former case I
don't think you can fseek stdin on either windows or *nix..
--
-- rouilj
John Rouillard System Administrator
Renesys Corporation 603-244-9084 (cell) 603-643-9300 x 111
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: rouilj@renesys.com, ineyman@perceptron.com
Subject: Re: parallel option in pg_restore
In-Reply-To: <20100622155149.GO703@renesys.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