Re: [Gnumed-devel] problem bootstrapping 0.3

[Karsten Hilbert]

On Wed, Jul 30, 2008 at 11:18:02AM +0200, Jerzy Luszawski wrote:

> The following messages seems to be important for your problem:

Jerzy, you are entirely correct.


> > 2008-07-30 09:49:18  INFO      gm.database 
> > (/home/gour/gnumed-server/GNUmed-v9-rc1/Gnumed/pycommon/gmPG2.py::get_connection()
> >  #1105): PostgreSQL version (string): "PostgreSQL 8.3.3 on 
> > x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.3.1"
> > 2008-07-30 09:49:18  INFO      gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::connect() #176): successfully connected
> > 2008-07-30 09:49:18  INFO      gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #382): 
> > template database LC_CTYPE is [C]
> > 2008-07-30 09:49:18  ERROR     gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #384): 
> > LC_CTYPE does not end in .UTF-8
> > 2008-07-30 09:49:18  ERROR     gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #385): 
> > cluster encoding incompatible with utf8 encoded databases but
> > 2008-07-30 09:49:18  ERROR     gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #386): 
> > for GNUmed installation the cluster must accept this encoding
> > 2008-07-30 09:49:18  ERROR     gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #387): 
> > you may need to re-initdb or create a new cluster
> > 2008-07-30 09:49:18  ERROR     gm.bootstrapper 
> > (./bootstrap_gm_db_system.py::__bootstrap() #337): Cannot connect to server 
> > template database.
>
> Probably postgresql inherited your locale setting from
> your system, and your system locale is not UTF-8. Try
> correcting your system locale and the locale for the
> template database.

This analysis is accurate. The recommended solution is to
re-initdb with an UTF8-compatible locale.

However, the above is a special case: Gour's locale is C. In
PostgreSQL storage terms this means: accept any encoding and
store it as is. This will not allow for proper locale
handling but will store the bytes themselves correctly.
Hence I have now IFDEFed this as an allowable special case.

Nonetheless .utf8 is recommended.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346