Show Table of Contents
9.3. Migrating the Data Warehouse Database to a Separate Machine
Optionally migrate the
ovirt_engine_history database before you migrate the Data Warehouse service. This procedure uses pg_dump to create a database backup, and psql to restore the backup on the new database machine. The pg_dump command provides flexible options for backing up and restoring databases; for more information on options that may be suitable for your system, see the pg_dump manual page.
The following procedure assumes that a PostgreSQL database has already been configured on the new machine. To migrate the Data Warehouse service only, see Section 9.4, “Migrating the Data Warehouse Service to a Separate Machine”.
Important
If the existing Data Warehouse database is connected to an existing Reports service, you must reconfigure that service by running
engine-setup and entering the details of the new Data Warehouse database when prompted. If you do not do this, the Reports service is still connected to the old database, and does not receive any new data.
Procedure 9.3. Migrating the Data Warehouse Database to a Separate Machine
- On the existing database machine, dump the
ovirt_engine_historydatabase into a SQL script file:# pg_dump ovirt_engine_history > ovirt_engine_history.sql
- Copy the script file from the existing database machine to the new database machine.
- Restore the
ovirt_engine_historydatabase on the new database machine:# psql -d ovirt_engine_history -f ovirt_engine_history.sql
The command above assumes that the database on the new machine is also namedovirt_engine_history.
Where did the comment section go?
Red Hat's documentation publication system recently went through an upgrade to enable speedier, more mobile-friendly content. We decided to re-evaluate our commenting platform to ensure that it meets your expectations and serves as an optimal feedback mechanism. During this redesign, we invite your input on providing feedback on Red Hat documentation via the discussion platform.