How do I ensure that the reports database is correctly saved?

Solution Verified - Updated -

Environment

  • Red Hat Enterprise Virtualization (RHEV) 3.1
  • Reports Database

Issue

  • Using RHEV 3.1 provided backup scripts.
  • How to ensure that the reports database is correctly saved.

Resolution

  • Take a separate backup of the Reports database. Reports has two types of Database (ovirt_engine_history and rhevmreports)

    • rhevm_history is the statistical database that contains the actual data about RHEV manager's history.
    # cd /usr/share/ovirt-engine/dbscripts 
# ./backup.sh -u postgres -v -d ovirt_engine_history -l /tmp/
    • rhevmreports is the configuration database for the rhevm-reports-server package. Take a backup of this database to save user, ad hoc reports and reports scheduling.
    # cd /usr/share/ovirt-engine/dbscripts 
# ./backup.sh -u postgres -v -d rhevmreports -l /tmp/

This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.

Comments