RHEV-M databse restore is very slow
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.