Description of problem:

https://access.redhat.com/documentation/en-us/red_hat_virtualization/4.2-beta/html/installation_guide/appe-preparing_a_remote_postgresql_database_for_use_with_the_red_hat_enterprise_virtualization_manager

for remote db postgresql.conf needs 'work_mem = 8192'. i would almost bet that i saw it somewhere in docs as my previous remote db env has this manually set.

if not set, this happens:

2018-01-25 16:48:29,096+0100 DEBUG otopi.context context.dumpEnvironment:833 ENV OVESETUP_DB/invalidConfigItems=list:'[{'name': 'Engine', 'current': '4096', 'key': 'work_mem', 'e
xpected': 8192, 'format_str': '{key} required to be at least {expected}', 'pg_host': '**FILTERED**.example.com'}]'
2018-01-25 16:48:29,097+0100 DEBUG otopi.context context.dumpEnvironment:837 ENVIRONMENT DUMP - END
2018-01-25 16:48:29,099+0100 DEBUG otopi.context context._executeMethod:128 Stage customization METHOD otopi.plugins.ovirt_engine_setup.ovirt_engine.db.configuration.Plugin._cust
omization
2018-01-25 16:48:29,100+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                
2018-01-25 16:48:29,100+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                 Found the following problems in PostgreSQL configuration fo
r the Engine database:
2018-01-25 16:48:29,101+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                  work_mem required to be at least 8192
2018-01-25 16:48:29,101+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                 Please set:
2018-01-25 16:48:29,102+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                  work_mem = 8192
2018-01-25 16:48:29,102+0100 DEBUG otopi.plugins.otopi.dialog.human dialog.__logString:204 DIALOG:SEND                 in postgresql.conf on '**FILTERED**.example.com'. Its locat
ion is usually /var/lib/pgsql/data , or somewhere under /etc/postgresql* .
2018-01-25 16:48:29,103+0100 DEBUG otopi.context context._executeMethod:143 method exception
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/otopi/context.py", line 133, in _executeMethod
    method['method']()
  File "/usr/share/ovirt-engine/setup/bin/../plugins/ovirt-engine-setup/ovirt-engine/db/configuration.py", line 245, in _customization
    'Please fix PostgreSQL configuration and retry.'
RuntimeError: Please fix PostgreSQL configuration and retry.
2018-01-25 16:48:29,105+0100 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Environment customization': Please fix PostgreSQL configuration and retry.