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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

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