Description of problem: e.g free EnterpriseDB server has higher version (now only 9.5 available) from postgres server installed with RHEL. engine-setup doesn't allow to install remote DB with different version, but we need it to force the installation because of EDB Version-Release number of selected component (if applicable): ovirt-engine-4.0.5-0.1.el7ev.noarch Actual results: [ ERROR ] Cannot connect to DWH database: Postgresql client version is '9.2.18', whereas the version on XX.XX.XX.XX is '9.5.0.5'. Please use a Postgresql server of version '9.2.18'. Expected results: not sure what to do, maybe engine-setup can inform about the difference and ask if the user wants to install engine anyway or it can check only first number in the version Additional info: The version check was added from this Bug 1331168
This was already discussed in bug 1331168. Either we find a way to use EDB client on the engine machine (how?) or we allow giving up on backup during upgrade (and restore/rollback on failure). Can you please try installing EDB client on the engine machine and see if engine-setup works? Also please try to upgrade, fail the upgrade, and see if it rolled back cleanly. Thanks.
I've installed EDB locally, had to overwrite psql/pg_dump/pg_restore in /usr/bin, add schema 'sys' to check of ownership. Engine runs without problems, backup/restore with problem described in Bug 1381180, but after restarting dwhd seems working also.