9.3. Migrating the Data Warehouse Database to a Separate Machine
ovirt_engine_historydatabase before you migrate the Data Warehouse service. This procedure uses
pg_dumpto create a database backup, and
psqlto restore the backup on the new database machine. The
pg_dumpcommand provides flexible options for backing up and restoring databases; for more information on options that may be suitable for your system, see the
engine-setupand 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.sqlThe command above assumes that the database on the new machine is also named