Bug 1381200

Summary:	force engine-setup to install EDB with different versions psql-server
Product:	[oVirt] ovirt-engine	Reporter:	Lucie Leistnerova <lleistne>
Component:	Setup.Engine	Assignee:	Yedidyah Bar David <didi>
Status:	CLOSED WONTFIX	QA Contact:	Pavel Stehlik <pstehlik>
Severity:	medium	Docs Contact:
Priority:	low
Version:	4.0.5	CC:	bugs, didi, lleistne, mkalinin, ylavi
Target Milestone:	---	Flags:	sbonazzo: ovirt-4.3-
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-04-04 19:43:59 UTC	Type:	Bug
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	Integration	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	1324882

Description Lucie Leistnerova 2016-10-03 12:07:21 UTC

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

Comment 1 Yedidyah Bar David 2016-10-05 08:43:50 UTC

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.

Comment 2 Lucie Leistnerova 2016-10-07 16:01:36 UTC

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.