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/[email protected]/msg47854.html I hope to try this today or tomorrow on a test system. Regards, Paul S. ________________________________ From: [email protected] <[email protected]> on behalf of Aziz <[email protected]> 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 <[email protected]<mailto:[email protected]>> 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 <[email protected]<mailto:[email protected]>> wrote: Show this information: 1 - su - postgresql 2 - psql 3 - \l Thanks, 2018-04-26 7:38 GMT-03:00 Marcelo Leandro <[email protected]<mailto:[email protected]>>: 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 <[email protected]<mailto:[email protected]>> 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-20180426122630-rpkrel.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20180426122823-setup.co<http://20180426122823-setup.co>nf' [ 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 [email protected]<mailto:[email protected]> 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
_______________________________________________ Users mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/users
