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

[Eli Mesika]

----- Original Message -----
> From: "Alon Bar-Lev" <alonbl at redhat.com>
> To: "Nux!" <nux at li.nux.ro>, "Eli Mesika" <emesika at redhat.com>
> Cc: "Yedidyah Bar David" <didi at redhat.com>, users at 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 at li.nux.ro>
> > To: "Yedidyah Bar David" <didi at redhat.com>
> > Cc: users at 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 at ovirt.org
> > http://lists.ovirt.org/mailman/listinfo/users
> > 
>