Appendix B. Preparing a Local Manually Configured PostgreSQL Database

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

1. Install the PostgreSQL server package:

   # dnf install postgresql-server postgresql-contrib

2. Initialize the PostgreSQL database instance:

   # postgresql-setup --initdb

3. Start the postgresql service, and ensure that this service starts on boot:

   # systemctl enable postgresql
   # systemctl start postgresql

4. Connect to the psql command line interface as the postgres user:

   # su - postgres -c psql

5. Create a default user. The Manager’s default user is engine and Data Warehouse’s default user is ovirt_engine_history:

   postgres=# create role user_name with login encrypted password 'password';

6. Create a database. The Manager’s default database name is engine and Data Warehouse’s default database name is ovirt_engine_history:

   postgres=# create database database_name owner user_name template template0 encoding 'UTF8' lc_collate 'en_US.UTF-8' lc_ctype 'en_US.UTF-8';

7. Connect to the new database:

   postgres=# \c database_name

8. Add the uuid-ossp extension:

   database_name=# CREATE EXTENSION "uuid-ossp";

9. Add the plpgsql language if it does not exist:

   database_name=# CREATE LANGUAGE plpgsql;

10. Quit the psql interface:

    database_name=# \q

11. Edit the /var/lib/pgsql/data/pg_hba.conf file to enable md5 client authentication, so the engine can access the database locally. Add the following line immediately below the line that starts with local at the bottom of the file:

    host    database_name    user_name    0.0.0.0/0    md5
    host    database_name    user_name    ::0/0   md5

12. Update the PostgreSQL server’s configuration. Edit the /var/lib/pgsql/data/postgresql.conf file and add the following lines to the bottom of the file:

    autovacuum_vacuum_scale_factor=0.01
    autovacuum_analyze_scale_factor=0.075
    autovacuum_max_workers=6
    maintenance_work_mem=65536
    max_connections=150
    work_mem=8192

13. Restart the postgresql service:

    # systemctl restart postgresql

14. Optionally, set up SSL to secure database connections.