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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
