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

[Staniforth, Paul]

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 at ovirt.org <users-bounces at ovirt.org> on behalf of Aziz <azizgstest at gmail.com>
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 at gmail.com<mailto:azizgstest at gmail.com>> wrote:
There you are :


[root at CTL1 tmp]# su - postgresql
su: user postgresql does not exist
[root at 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 at gmail.com<mailto:marceloltmm at gmail.com>> wrote:

Show this information:

1 - su - postgresql
2 - psql
3 - \l


Thanks,

2018-04-26 7:38 GMT-03:00 Marcelo Leandro <marceloltmm at gmail.com<mailto:marceloltmm at gmail.com>>:
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 at gmail.com<mailto:azizgstest at gmail.com>> 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
Users at ovirt.org<mailto:Users at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.ovirt.org/pipermail/users/attachments/20180426/8e9b8992/attachment.html>