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, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content