Note: This is a beta release of Red Hat Bugzilla 5.0. The data contained within is a snapshot of the live data so any changes you make will not be reflected in the production Bugzilla. Also email is disabled so feel free to test any aspect of the site that you want. File any problems you find or give feedback here.

Bug 1690884

Summary: RHV 4.2.8 dump generation fails with pg_dump: server version: 9.5.14; pg_dump version: 9.2.24
Product: Red Hat Enterprise Virtualization Manager Reporter: Antonio Romito <aromito>
Component: rh-postgresql95Assignee: Martin Perina <mperina>
Status: NEW --- QA Contact: Lukas Svaty <lsvaty>
Severity: medium Docs Contact:
Priority: unspecified    
Version: 4.2.8-3CC: aperotti, aromito
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Infra RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Antonio Romito 2019-03-20 11:57:28 UTC
Description of problem:

Trying to generate a dump of the postgres database pg_dump fails with the following error:

pg_dump: server version: 9.5.14; pg_dump version: 9.2.24
pg_dump: aborting because of server version mismatch

Version-Release number of selected component (if applicable):

[root@rhvm-float tmp]# rpm -qa | grep postgresql | sort
...
postgresql-9.2.24-1.el7_5.x86_64
postgresql-jdbc-9.2.1002-6.el7_5.noarch
postgresql-libs-9.2.24-1.el7_5.x86_64
postgresql-server-9.2.24-1.el7_5.x86_64
rh-postgresql95-postgresql-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-contrib-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-libs-9.5.14-1.el7.x86_64
rh-postgresql95-postgresql-server-9.5.14-1.el7.x86_64
rh-postgresql95-runtime-2.2-2.el7.x86_64


How reproducible:

[root@rhvm-float ~]# source /etc/ovirt-engine/engine.conf.d/10-setup-database.conf
[root@rhvm-float ~]# PGPASSWORD=$ENGINE_DB_PASSWORD pg_dump -h localhost -U $ENGINE_DB_USER -w -f /tmp/enginedb-$(date +%F_%T).dump -F t $ENGINE_DB_DATABASE
pg_dump: server version: 9.5.14; pg_dump version: 9.2.24
pg_dump: aborting because of server version mismatch


Steps to Reproduce:
1.
2.
3.

Actual results:

dump generation fails with following errors:

pg_dump: server version: 9.5.14; pg_dump version: 9.2.24
pg_dump: aborting because of server version mismatch


Expected results:

[root@rhvm-float ~]# source /etc/ovirt-engine/engine.conf.d/10-setup-database.conf
[root@rhvm-float ~]# scl enable rh-postgresql95 "PGPASSWORD=$ENGINE_DB_PASSWORD pg_dump -h localhost -U $ENGINE_DB_USER -w -f /tmp/enginedb-$(date +%F_%T).dump -F t $ENGINE_DB_DATABASE"


Additional info:

Probably we should remove the duplicate packages of postgresql in favor of rh-postgresql95-*