> -----Original Message----- > From: Tom Lane [mailto:t...@sss.pgh.pa.us] > Sent: Tuesday, June 22, 2010 10:37 AM > To: Igor Neyman > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] parallel option in pg_restore > > "Igor Neyman" <iney...@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 > >
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. Regards, Igor Neyman
CM_200608_Restore.log
Description: CM_200608_Restore.log
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
