> From: Igor Neyman <ineyman@xxxxxxxxxxxxxx> > Subject: Re: parallel option in pg_restore > To: "Tom Lane" <tgl@xxxxxxxxxxxxx> > Cc: pgsql-admin@xxxxxxxxxxxxxx > Date: Tuesday, 22 June, 2010, 16:05 > > -----Original Message----- > > From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] > > > Sent: Tuesday, June 22, 2010 10:37 AM > > To: Igor Neyman > > Cc: pgsql-admin@xxxxxxxxxxxxxx > > Subject: Re: parallel option in pg_restore > > > > "Igor Neyman" <ineyman@xxxxxxxxxxxxxx> > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
