Errors while restoring database engine
Issue
-
Cannot perform RHV upgrade
-
engine-backup restore fails with:
pg_restore: [archiver (db)] Error from TOC entry 5451; 2606 18884743 FK CONSTRAINT fk_event_notification_hist_audit_log engine
pg_restore: [archiver (db)] could not execute query: ERROR: there is no unique constraint matching given keys for referenced table "audit_log"
Command was: ALTER TABLE ONLY event_notification_hist
ADD CONSTRAINT fk_event_notification_hist_audit_log FOREIGN KEY (audit_log_id) ...
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges could be revoked for "public"
pg_restore: WARNING: no privileges were granted for "public"
pg_restore: WARNING: no privileges were granted for "public"
WARNING: errors ignored on restore: 4
2018-09-06 14:54:54 15172: FATAL: Errors while restoring database engine
Environment
- Red Hat Virtualization
- Upgrade
- PostgresQL
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.