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

Re: parallel option in pg_restore

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Igor Neyman <ineyman(at)perceptron(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: parallel option in pg_restore
Date: 2010-06-22 15:26:34
Message-ID: 412620.30094.qm@web23607.mail.ird.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
> From: Igor Neyman <ineyman(at)perceptron(dot)com>
> Subject: Re: [ADMIN] parallel option in pg_restore
> To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Cc: pgsql-admin(at)postgresql(dot)org
> Date: Tuesday, 22 June, 2010, 16:05
> > -----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.
> 

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




      

In response to

pgsql-admin by date

Next:From: Tom LaneDate: 2010-06-22 15:35:48
Subject: Re: parallel option in pg_restore
Previous:From: Igor NeymanDate: 2010-06-22 15:05:02
Subject: Re: parallel option in pg_restore

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