Errors while restoring database engine

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.