BTW: I already tried to change the postgresql-setup(/opt/rh/rh-postgresql95/root/usr/bin/postgresql-setup) as I found in a postgresql forum:

export LANG=en_US.UTF-8
export LANGUAGE="en_US.UTF-8"
export LANG="en_US.UTF-8"
export LC_ALL="en_US.UTF-8"

Didn't help.

Thanks!




Gabriel Stein
------------------------------
Gabriel Ferraz Stein
Tel.: +49 (0)  170 2881531

2017-12-20 16:07 GMT+01:00 Gabriel Stein <gabrielstein@gmail.com>:
Hi!

well, I'm a update fever and I decided to update my ovirt to 4.2.0.

How I'm doingi it? 

I'm following the rules!

1 - Global Maintenance Mode
2 - Yum Install ovirt-release-4.2
3- yum update ovirt-setup*.

But, by the engine-setup I have a conflict with the system collation and postgresql. Unfortunatelly I changed via puppet to the german collation(de_DE-UTF8) of ovirt-engine hosted vm(because it's a standard for us) but this was after the engine-setup and the DB Configuration from Postgresql.

I think that I can easily change the system collation to us-US-UFT8 but I'm afraid that I can "destroy" my hosted-engine VM with that change, is hosted-engine so sensible?

How I know that error?  The logs are saying that(and the error in on postgresql upgrade part of setup)!

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

lc_collate values for database "postgres" do not match:  old "en_US.UTF-8", new "de_DE.UTF-8"
Failure, exiting

I would be thankful if someone could give me some hint about that!

Best Regards,

Gabriel
PS: If I go to devconf in Brno I will pay a lot of beers to the developer of the engine-setup rollback! Saved my life!






Gabriel Stein
------------------------------
Gabriel Ferraz Stein
Tel.: +49 (0)  170 2881531