Hello,

I have problem when i try upgrade the ovirt to 4.2,  my version is 4.1.9, I have problem when engine-setup try update the postgresql.

Postgres version 9.2

I had this message:

Log install:

ERROR: pg_upgrade tool failed

ERROR: Upgrade failed.

 * See /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log for details.

2018-04-21 04:53:10,766-0300 DEBUG otopi.transaction transaction._prepare:66 exception during prepare phase

Traceback (most recent call last):

  File "/usr/lib/python2.7/site-packages/otopi/transaction.py", line 62, in _prepare

    element.prepare()

  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/postgres.py", line 777, in prepare

    raiseOnError=True,

  File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 931, in execute

    command=args[0],

RuntimeError: Command '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute

2018-04-21 04:53:10,768-0300 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/dbmsupgrade.py", line 89, in _updateDBMS

    oengcommcons.ProvisioningEnv.OLD_POSTGRES_SERVICE

  File "/usr/lib/python2.7/site-packages/otopi/transaction.py", line 106, in append

    self._prepare(element=element)

  File "/usr/lib/python2.7/site-packages/otopi/transaction.py", line 62, in _prepare

    element.prepare()

  File "/usr/share/ovirt-engine/setup/ovirt_engine_setup/engine_common/postgres.py", line 777, in prepare

    raiseOnError=True,

  File "/usr/lib/python2.7/site-packages/otopi/plugin.py", line 931, in execute

    command=args[0],

RuntimeError: Command '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute

2018-04-21 04:53:10,770-0300 ERROR otopi.context context._executeMethod:152 Failed to execute stage 'Misc configuration': Command '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute

Log postgres:

Performing Consistency Checks

-----------------------------

Checking cluster versions                                   ok

Checking database user is the install user                  ok

Checking database connection settings                       ok

Checking for prepared transactions                          ok

Checking for reg* system OID user data types                ok

Checking for contrib/isn with bigint-passing mismatch       ok

Checking for invalid "line" user columns                    ok

Creating dump of global objects                             ok

Creating dump of database schemas

  engine

  ovirt_engine_history

  postgres

  template1

                                                            ok

encodings for database "postgres" do not match:  old "SQL_ASCII", new "UTF8"

Failure, exiting

I know that problem not is in oVirt , but anyone help me ?

Thank you!