Re: [Users] engine-setup fails on CentOS 6.4 because of postgresql

From: "Eli Mesika" <emesika(a)redhat.com&gt; To: "Alon Bar-Lev" <alonbl(a)redhat.com&gt; Cc: "Nux!" <nux(a)li.nux.ro&gt;, "Yedidyah Bar David" <didi(a)redhat.com&gt;, users(a)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(a)redhat.com&gt; > To: "Nux!" <nux(a)li.nux.ro&gt;, "Eli Mesika" <emesika(a)redhat.com&gt; > Cc: "Yedidyah Bar David" <didi(a)redhat.com&gt;, users(a)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(a)li.nux.ro&gt; > > To: "Yedidyah Bar David" <didi(a)redhat.com&gt; > > Cc: users(a)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

> > > > > Lucian > > > > -- > > Sent from the Delta quadrant using Borg technology! > > > > Nux! > > www.nux.ro > > _______________________________________________ > > Users mailing list > > Users(a)ovirt.org > > http://lists.ovirt.org/mailman/listinfo/users > > >