Re: parallel option in pg_restore

"Igor Neyman" <ineyman(at)perceptron(dot)com> writes:
> Attached are couple smallish files (I suspect, CM_200909.bac might have
> just empty tables, no data - but it still produces an errror).

Hmm. I get

pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2741; 1259 30866 TABLE gp_cycle_200907 vec_dba
pg_restore: [archiver (db)] could not execute query: ERROR: relation "gp_cycle" does not exist
Command was:
CREATE TABLE gp_cycle_200907 (CONSTRAINT gp_cycle_200907_cycle_date_time_check CHECK (((cycle_date_time >= '2009-07-01 00:0...

The tables all seem to inherit from tables you omitted from the dump,
so of course it's not restorable for anyone else.

Now I do see

pg_restore: [custom archiver] dumping a specific TOC data block out of order is not supported without ID on this input stream (fseek required)

after that, but I'm wondering if this is just a problem in error
recovery rather than the bug we thought we were looking for.

regards, tom lane