"Igor Neyman" <[email protected]> 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
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
