Hello,
i'm trying to restore cmdbuild 3.0 db with pg_restore, but the operation failed with error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 7; 2615 12121 SCHEMA information_schema postgres
pg_restore: [archiver (db)] could not execute query: ERROR: schema "information_schema" already exists
Command was: CREATE SCHEMA "information_schema";
it sounds like pg_dump is dumping the information_schema, which it should not do.
May be some sort of version skew issue?
Thx, Arben