"Igor Neyman" <ineyman@perceptron.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