Chapter 2. Migrating the Data Warehouse to a Separate Machine

Procedure

1. Register your system with the Content Delivery Network, entering your Customer Portal user name and password when prompted:

   # subscription-manager register

   Note

   If you are using an IPv6 network, use an IPv6 transition mechanism to access the Content Delivery Network and subscription manager.

2. Find the Red Hat Virtualization Manager subscription pool and record the pool ID:

   # subscription-manager list --available

3. Use the pool ID to attach the subscription to the system:

   # subscription-manager attach --pool=pool_id

   Note

   To view currently attached subscriptions:

   # subscription-manager list --consumed

   To list all enabled repositories:

   # dnf repolist

4. Configure the repositories:

   # subscription-manager repos \
       --disable='*' \
       --enable=rhel-8-for-x86_64-baseos-eus-rpms \
       --enable=rhel-8-for-x86_64-appstream-eus-rpms \
       --enable=rhv-4.4-manager-for-rhel-8-x86_64-rpms \
       --enable=fast-datapath-for-rhel-8-x86_64-rpms \
       --enable=jb-eap-7.4-for-rhel-8-x86_64-rpms \
       --enable=openstack-16.2-cinderlib-for-rhel-8-x86_64-rpms \
       --enable=rhceph-4-tools-for-rhel-8-x86_64-rpms \
       --enable=rhel-8-for-x86_64-appstream-tus-rpms \
       --enable=rhel-8-for-x86_64-baseos-tus-rpms

5. Set the RHEL version to 8.6:

   # subscription-manager release --set=8.6

6. Enable version 12 of the postgresql module.

   # dnf module -y enable postgresql:12

7. Enable version 14 of the nodejs module:

   # dnf module -y enable nodejs:14

8. Synchronize installed packages to update them to the latest available versions.

   # dnf distro-sync --nobest

Procedure

1. Create a backup of the Data Warehouse database and configuration files on the Manager:

   # engine-backup --mode=backup --scope=grafanadb --scope=dwhdb --scope=files --file=file_name --log=log_file_name

2. Copy the backup file from the Manager to the new machine:

   # scp /tmp/file_name root@new.dwh.server.com:/tmp

3. Install engine-backup on the new machine:

   # dnf install ovirt-engine-tools-backup

4. Install the PostgreSQL server package:

   # dnf install postgresql-server postgresql-contrib

5. Initialize the PostgreSQL database, start the postgresql service, and ensure that this service starts on boot:

   # su - postgres -c 'initdb'
   # systemctl enable postgresql
   # systemctl start postgresql

6. Restore the Data Warehouse database on the new machine. file_name is the backup file copied from the Manager.

   # engine-backup --mode=restore --scope=files --scope=grafanadb --scope=dwhdb --file=file_name --log=log_file_name --provision-dwh-db

   When the --provision-* option is used in restore mode, --restore-permissions is applied by default.