[Pkg-postgresql-public] Bug#743914: [postgresql-9.1] Locale of postgresql default table in live-system

[Louis-Maurice De Sousa]

Le 09/04/2014 13:19, Christoph Berg a écrit :
> Re: Louis-Maurice De Sousa 2014-04-08 <5343C3EF.8000902 at crdp.ac-versailles.fr>
>> I filled this bug for live-boot :
>> https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=743187
>>
>> They suggest it could be possible to have a hook to force creation UTF-8
>> test table during the chroot.
>
> Hi Louis-Maurice,

Sorry for this late answer, but I tried a couple of things before 
writing again.

> they suggested you added a hook in your live scripts, not in the
> postgresql package.
>

Yes, I understood that but I thought you could help me finding the right 
hook. :-)

I tried this.
A hook file named postgresql-9.1.chroot was created and contains these 
actions :
sudo pg_dropcluster --stop 9.1 main
sudo pg_createcluster --locale fr_FR.UTF-8 --start 9.1 main
sudo aptitude install silan airtime

A new utf-8 table is created, but this brakes all the configurations we 
made to the live image. And Airtime doesn't work either.

Is there any debconf directive we could give to force the test table 
created in the chroot, to be in UTF-8 ?
What misconfiguration could I have for Postgresql create an ASCII test 
table in the chroot, instead of an UTF-8 one ?

This is for an educational project we named StudioBox. We propose a 
DebianLive system to teachers, with everything for radio streaming and 
podcast. This is why we need Airtime installed.
For the moment the workaround is to install Airtime and Postgresql 
*after* the first boot of the live system. But those sofwares are then 
in the persistent partition and this is not really satisfactory.

Thanks for your help.

-- 

Louis-Maurice De Sousa