From: | soumitra bhandary <soumitra(dot)bhandary(at)hotmail(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Pg_restore failing due to data inconsistency in dump file |
Date: | 2018-12-13 11:20:18 |
Message-ID: | MA1PR0101MB16876D291572530CED5E798DE0A00@MA1PR0101MB1687.INDPRD01.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello Team ,
I have encountered following issue while restoring the Postgres dump using pg_restore . Please provide any suggestion to the same .
1. This dump was taken using bdr_dump as bdr enabled database and all the BDR configuration and extension was excluded .
2. DUMP was taken in a running DB server where BDR was running .
3. Postgres Dump was taken in .dump format .
4. 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".
Thanks ,
Soumitra
From | Date | Subject | |
---|---|---|---|
Next Message | Shreeyansh Dba | 2018-12-13 12:21:41 | Re: Pg_restore failing due to data inconsistency in dump file |
Previous Message | Shreeyansh Dba | 2018-12-12 11:46:17 | Re: PG Encryption / pg_read_file |