Description of problem:

Need to add the following information into 2.6 section in DWH Guide

https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.1/html/data_warehouse_guide/allowing_read_only_access_to_the_history_database


Before running the 'psql' command after step 6, customer still needs to configure the authentication method for the read-only user in ph_hba.conf file + reload postgresql service, also, the psql command, to test access to the ovirt_engine_history DB, has to include the host flag (-h localhost)

# /var/lib/pgsql/data/pg_hba.conf
~~~
# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
host    ovirt_engine_history ovirt_engine_history 0.0.0.0/0               md5
host    ovirt_engine_history ovirt_engine_history ::0/0                   md5
host    ovirt_engine_history $RO_USER 0.0.0.0/0               md5
host    ovirt_engine_history $RO_USER ::0/0                   md5
host    engine          engine          0.0.0.0/0               md5
host    engine          engine          ::0/0                   md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            ident
# IPv6 local connections:
host    all             all             ::1/128                 ident
~~~

Replace $RO_USER with correct value


# systemctl reload postgresql

Command to test DB access:

# psql -h localhost -U $RO_USER ovirt_engine_history