Re: [Gnumed-devel] Postgres 8.4.4-1 (Enterprise db) problems -- system hosed?

[Sebastian Hilbert]

> 
>       Select the locale to be used by the new database cluster
>       [Default locale]
> 
> ---> I set this to en_CA

Set it to C. This stupid bug has been there for ages  and I believe this is 
due to the fact that the closed source bitrock installer tries to work on 
Windows and MacOS.

Unless I am mistaken Windows does not have UTF8 but Mac (BSD) has. That is 
what you get from a closed source installer.

Anyway using 'C' will work.

I guess this little issue could drive us into the arms of the macports 
version.

Someone would have to investigate of the macports version would be.
For one one would need to set a postgres password on the command line.

there will be no start/stop scripts in applications ? However one could lift 
those from the enterprisedb version I guess.

Still we have always said that for in the wild installations a support company 
should be hired. Those 'professionals' should be able to properly set this up.
And since PG needs to be set up only once in your life I don't see a problem 
there.

Sebastian

> 
> but from the GNUmed bootstrap log:
> 
> 2010-06-30 23:36:27  INFO      gm.bootstrapper
> (./bootstrap_gm_db_system.py::connect() #256): successfully connected
> 2010-06-30 23:36:27  INFO      gm.bootstrapper
> (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #371):
> template database LC_CTYPE is [en_CA] 2010-06-30 23:36:27  ERROR    
> gm.bootstrapper
> (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #378):
> LC_CTYPE does not end in .UTF-8 or .UTF8 2010-06-30 23:36:27  ERROR    
> gm.bootstrapper
> (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #379):
> cluster encoding incompatible with utf8 encoded databases but 2010-06-30
> 23:36:27  ERROR     gm.bootstrapper
> (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #380):
> for GNUmed installation the cluster must accept this encoding 2010-06-30
> 23:36:27  ERROR     gm.bootstrapper
> (./bootstrap_gm_db_system.py::__connect_superuser_to_srv_template() #381):
> you may need to re-initdb or create a new cluster 2010-06-30 23:36:27 
> ERROR     gm.bootstrapper (./bootstrap_gm_db_system.py::__bootstrap()
> #320): Cannot connect to server template database. 2010-06-30 23:36:27 
> ERROR     gm.bootstrapper (./bootstrap_gm_db_system.py::bootstrap()
> #1125): Cannot bootstrap bundle [config].