Skip site navigation (1) Skip section navigation (2)

Re: parallel option in pg_restore

From: "Igor Neyman" <ineyman(at)perceptron(dot)com>
To: "John Rouillard" <rouilj(at)renesys(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: parallel option in pg_restore
Date: 2010-06-22 16:34:12
Message-ID: F4C27E77F7A33E4CA98C19A9DC6722A20625203E@EXCHANGE.corp.perceptron.com (view raw or flat)
Thread:
Lists: pgsql-admin
 

> -----Original Message-----
> From: John Rouillard [mailto:rouilj(at)renesys(dot)com] 
> Sent: Tuesday, June 22, 2010 11:52 AM
> To: Igor Neyman
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] parallel option in pg_restore
> 
> On Tue, Jun 22, 2010 at 11:05:02AM -0400, Igor Neyman wrote:
> > > "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
> 
> > 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
> 
> 

No piping, just regular restore from the backup file.

Regards,
Igor Neyman

In response to

Responses

pgsql-admin by date

Next:From: Glyn AstillDate: 2010-06-22 16:36:10
Subject: Re: parallel option in pg_restore
Previous:From: Uwe BartelsDate: 2010-06-22 15:59:24
Subject: Re: blocking automatic vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group