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

[Alon Bar-Lev]

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

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 at ovirt.org
> > > http://lists.ovirt.org/mailman/listinfo/users
> > > 
> > 
>