Re: [ovirt-users] Failed to upgrade from 4.1 to 4.2 - Postgre version required

I'm having this problem as well. It's suggested here to backup the databases and install new clean version of postgresql with the correct encoding,collation, etc and restore the databases. https://www.mail-archive.com/users@ovirt.org/msg47854.html I hope to try this today or tomorrow on a test system. Regards, Paul S. ------------------------------ *From:* users-bounces(a)ovirt.org <users-bounces(a)ovirt.org&gt; on behalf of Aziz <azizgstest(a)gmail.com&gt; *Sent:* 26 April 2018 12:15 *To:* Marcelo Leandro *Cc:* users *Subject:* Re: [ovirt-users] Failed to upgrade from 4.1 to 4.2 - Postgre version required This is similar to the below bug : https://bugzilla.redhat.com/show_bug.cgi?id=1528371 Any ideas on how to fix it without losing the existing config ? Thank you. On Thu, Apr 26, 2018 at 11:54 AM, Aziz <azizgstest(a)gmail.com&gt; wrote: > There you are : > > > [root@CTL1 tmp]# su - postgresql > su: user postgresql does not exist > [root@CTL1 tmp]# su - postgres > Last login: Thu Apr 26 12:25:01 CEST 2018 on pts/0 > nodectl must be run as root! > nodectl must be run as root! > nodectl must be run as root! > nodectl must be run as root! > -bash-4.2$ psql > psql (9.2.23) > Saisissez « help » pour l'aide. > > postgres=# \l > Liste des bases de données > Nom | Propriétaire | Encodage | Collationnement > | Type caract. | Droits d'accès > ----------------------+----------------------+----------+--- > --------------+--------------+----------------------- > dwh | postgres | UTF8 | fr_FR.UTF-8 > | fr_FR.UTF-8 | =Tc/postgres + > | | | > | | postgres=CTc/postgres > engine | engine | UTF8 | en_US.UTF-8 > | en_US.UTF-8 | > ovirt_engine_history | ovirt_engine_history | UTF8 | en_US.UTF-8 > | en_US.UTF-8 | > postgres | postgres | UTF8 | fr_FR.UTF-8 > | fr_FR.UTF-8 | > template0 | postgres | UTF8 | fr_FR.UTF-8 > | fr_FR.UTF-8 | =c/postgres + > | | | > | | postgres=CTc/postgres > template1 | postgres | UTF8 | fr_FR.UTF-8 > | fr_FR.UTF-8 | =c/postgres + > | | | > | | postgres=CTc/postgres > (6 lignes) > > postgres=# > > Thanks > > On Thu, Apr 26, 2018 at 11:49 AM, Marcelo Leandro <marceloltmm(a)gmail.com&gt; > wrote: > >> >> Show this information: >> >> 1 - su - postgresql >> 2 - psql >> 3 - \l >> >> >> Thanks, >> >> 2018-04-26 7:38 GMT-03:00 Marcelo Leandro <marceloltmm(a)gmail.com&gt;: >> >>> What show in the /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log >>> ? >>> >>> command: >>> cat /var/lib/pgsql/upgrade_rh-postgresql95-postgresql.log >>> >>> Marcelo Leandro >>> >>> Em qui, 26 de abr de 2018 07:34, Aziz <azizgstest(a)gmail.com&gt; escreveu: >>> >>>> Hi Ovirt users, >>>> >>>> I'm trying to upgrade my Ovirt from version 4.1 to 4.2, but I'm stuck >>>> when issuing the command *engine-setup* which returns the following >>>> errors : >>>> >>>> Upgrading PostgreSQL >>>> *[ ERROR ] Failed to execute stage 'Misc configuration': Command >>>> '/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup' failed to execute* >>>> [ INFO ] Yum Performing yum transaction rollback >>>> [ INFO ] Rolling back to the previous PostgreSQL instance >>>> (postgresql). >>>> [ INFO ] Stage: Clean up Log file is located at >>>> /var/log/ovirt-engine/setup/ovirt-engine-setup-2018042612263 >>>> 0-rpkrel.log >>>> [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/ >>>> 20180426122823-setup.conf' >>>> [ INFO ] Stage: Pre-termination >>>> [ INFO ] Stage: Termination >>>> *[ ERROR ] Execution of setup failed* >>>> >>>> >>>> Can anyone help to resolve this ? >>>> >>>> >>>> Thank you in advance. >>>> >>>> BR. >>>> _______________________________________________ >>>> Users mailing list >>>> Users(a)ovirt.org >>>> http://lists.ovirt.org/mailman/listinfo/users >>>> >>> >> > To view the terms under which this email is distributed, please go to:- http://disclaimer.leedsbeckett.ac.uk/disclaimer/disclaimer.html