----- Original Message -----
From: "Eli Mesika" <emesika@redhat.com> To: "Alon Bar-Lev" <alonbl@redhat.com> Cc: "Nux!" <nux@li.nux.ro>, "Yedidyah Bar David" <didi@redhat.com>, users@ovirt.org Sent: Wednesday, September 18, 2013 1:03:53 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
----- Original Message -----
From: "Alon Bar-Lev" <alonbl@redhat.com> To: "Nux!" <nux@li.nux.ro>, "Eli Mesika" <emesika@redhat.com> Cc: "Yedidyah Bar David" <didi@redhat.com>, users@ovirt.org Sent: Wednesday, August 28, 2013 1:56:19 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
----- Original Message -----
From: "Nux!" <nux@li.nux.ro> To: "Yedidyah Bar David" <didi@redhat.com> Cc: users@ovirt.org Sent: Wednesday, August 28, 2013 1:49:25 PM Subject: Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql
On 28.08.2013 10:13, Yedidyah Bar David wrote:
I think it's the OS's locale. What do you have in /etc/locale.conf ? You can try changing that to:
LANG="en_US.UTF-8"
Then login again (or just open a new shell), and verify that it worked by running:
locale
and verifying that there are no errors.
Hi,
It worked after I reinitialised the DB like this:
initdb --locale=C -E UNICODE -D /var/lib/pgsql/data
Might be nice to be able to specify/force this from /etc/sysconfig or similar, this is not very user friendly. :-)
Thanks for your help!
This is strange!
We use standard way to create the database: fedora: /usr/bin/postgresql-setup rhel/centos /etc/init.d/postgresql initdb
Both run: $SU -l postgres -c "$PGENGINE/initdb --pgdata='$PGDATA' --auth='ident'" >> "$PGLOG" 2>&1 < /dev/null
So we cannot provide parameters to this process... And we cannot specify locale environment variables as it uses su.
Eli, is there any solution for this?
Alon Our original create_db.sh script (3.2) had this line :
createdb --username=${USERNAME} --host=${SERVERNAME} --port=${PORT} ${DATABASE} -e -E UTF8 --lc-collate en_US.UTF8 --lc-ctype en_US.UTF8 -T template0
I know that in 3.3 , DB is created differently, you should make sure that the -E UTF8 --lc-collate en_US.UTF8 --lc-ctype en_US.UTF8 are used when DB is created
Fixed[1] [1] http://gerrit.ovirt.org/#/q/Id742da121c75d4268bdd9dddfb6e2ee48434ff2e,n,z
Lucian
-- Sent from the Delta quadrant using Borg technology!
Nux! www.nux.ro _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users