RHEV-M databse restore is very slow

Solution Unverified - Updated -

Issue

The RHEV manager's (RHEV-M) database (DB) become bigger and time for restore is longer.
It takes about 40 minutes to restore the RHEV-M DB, during a test of our disaster recovery procedures.
The following commands are used to backup/restore the DB:

  • Backup
pg_dump -C -E UTF8 --column-inserts --disable-dollar-quoting --disable-triggers -U postgres --format=p -f /usr/share/rhevm/db-backups/dump_RHEVDB_BACKUP_`date "+%Y%m%d_%R"`.sql rhevm
  • Restore
psql -U postgres -d rhevm -W -f /usr/share/rhevm/db-backups/dump_RHEVDB_BACKUP_`date "+%Y%m%d_%R"`.sql

Environment

  • Red Hat Enterprise Virtualization (RHEV) all versions

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