> -----Original Message----- > From: John Rouillard [mailto:rouilj@xxxxxxxxxxx] > Sent: Tuesday, June 22, 2010 11:52 AM > To: Igor Neyman > Cc: pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: parallel option in pg_restore > > On Tue, Jun 22, 2010 at 11:05:02AM -0400, Igor Neyman wrote: > > > "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 > > > 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
