Hi Simone,
if I use the same command as you did I get the following information:
[root@ovirt-engine ~]# sudo -u postgres scl enable rh-postgresql95 -- psql --list
could not change directory to "/root": Permission denied
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
----------------------+----------------------+-----------+-------------+-------------+-----------------------
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 | SQL_ASCII | C | C |
template0 | postgres | SQL_ASCII | C | C | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
(5 rows)
As I’m not a DB admin, I don’t really know how go about these encodings. I restored the current system from a 4.1.7 Backup
to a 4.1.9 image and all went well.
Do you need any other values ?
Thanks,
Sven
Von: Simone Tiraboschi [mailto:stirabos@redhat.com]
Gesendet: Dienstag, 24. Juli 2018 15:47
An: Sven Achtelik <Sven.Achtelik@eps.aero>; Yedidyah Bar David <didi@redhat.com>
Cc: users <users@ovirt.org>; Gobinda Das <godas@redhat.com>
Betreff: Re: [ovirt-users] Re: Upgrade from 4.1 to 4.2 failing - SQL Issues
Hi,
it seams still pretty close to https://bugzilla.redhat.com/show_bug.cgi?id=1528371 although that one was on lc_collate and this on encoding.
Adding also Didi.
I just double check on a system of mine upgrade from 4.1 to 4.2 and template1 is still on UTF8.
[root@enginevm tmp]# sudo -u postgres scl enable rh-postgresql95 -- psql --list
List of databases
Name | Owner | Encoding | Collate | Ctype | Access privileges
----------------------+----------------------+----------+-------------+-------------+-----------------------
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 | en_US.UTF-8 | en_US.UTF-8 |
template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres +
| | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres=CTc/postgres+
| | | | | =c/postgres
(5 rows)
So the point is why the upgrade process is trying to force SQL_ASCII.
Can you please share your env variable values?
On Tue, Jul 24, 2018 at 2:57 PM Gobinda Das <godas@redhat.com> wrote: