I have encountered following issue while restoring the Postgres dump using pg_restore . Please provide any suggestion to the same .
This dump was taken using bdr_dump as bdr enabled database and all the BDR configuration and extension was excluded .
DUMP was taken in a running DB server where BDR was running .
Postgres Dump was taken in .dump format .
During restoration of the same using pg_restore getting following error .
Error :
pg_restore:[archiver (db)]Error from TOC entry 3061; 2606 17551 FK CONSTRAINT fk_5hrm2vlf9ql5fu043kqepovbr DBNAME pg_restore:[archiver (db)]could not execute query: ERROR: insert or update on table "user_attribute" violates foreign key constraint "fk_5hrm2vlf9ql5fu043kqepovbr" DETAIL: Key (user_id)=(1f34ec07-7087-45ff-8a56-f36177752499) is not present in table "user_entity". Command was: ALTER TABLE ONLY user_attribute ADD CONSTRAINT fk_5hrm2vlf9ql5fu043kqepovbr FOREIGN KEY (user_id) REFERENCES user_entity... pg_restore:[archiver (db)]Error from TOC entry 3065; 2606 17601 FK CONSTRAINT fk_c4fqv34p1mbylloxang7b1q3l DBNAME pg_restore:[archiver (db)]could not execute query: ERROR: insert or update on table "user_role_mapping" violates foreign key constraint "fk_c4fqv34p1mbylloxang7b1q3l" DETAIL: Key (user_id)=(24d1ee2a-b05e-4c30-a292-84045c47611e) is not present in table "user_entity".