System State and History

When you install and configure Oracle Linux Virtualization Manager, you are prompted to install and configure the engine and data warehouse PostgreSQL databases. See Engine Configuration Options in the Oracle Linux Virtualization Manager: Getting Started Guide.

• The engine database (engine) stores information about the state of the Oracle Linux Virtualization Manager environment and its configuration and performance.
• The data warehouse database is a management history database (ovirt_engine_history) that can be used by any application to retrieve historical configuration information and statistical metrics for data centers, clusters, and hosts.

The data warehouse service (ovirt-engine-dwd) extracts data from the engine database and loads it into the ovirt_engine_history database. This is commonly known as ETL (extract, transform, load).

Both the history and engine databases can run on a remote host to reduce the load on the Manager host. Running these databases on a remote host is a technology preview feature, see Technology Preview in the Oracle Linux Virtualization Manager: Release Notes.

For more information, see Data Warehouse and Databases.