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

[Sebastian Hilbert]

Am Donnerstag 01 Juli 2010, 21:13:09 schrieb Jim Busser:
> On 2010-07-01, at 3:29 AM, Karsten Hilbert wrote:
> >> en_CA
> >> 
> >>    --> client_encoding = UNICODE (I think)
> 
> correction: I think I misread the bootstrapper log. The file
> 
>       Postgresql.conf
> 
> comments -out (#) the setting client_encoding, in fact it says
> 
> #client_encoding = sql_ascii          # actually, defaults to database
>                                       # encoding
> 
> > That should'a worked as well, maybe we can improve the test
> > 
> > as Sebastian suggested:
> >             # verify encoding
> 
> so given what was returned by (system user postgres calling)
> 
>       psql -l
> 
> can the bootstrapper be improved to recognize that UTF8 is in fact
> available?

It already is as per Karsten's posting

    srv_enc = srv_enc.lower()
                        if not srv_enc in ['utf8', 'utf-8']:
                                _log.error('cluster encoding incompatible with 
utf8 encoded databases but')
                                _log.error('for GNUmed installation the 
cluster must accept this encoding')
                                _log.error('you may need to re-initdb or 
create a new cluster')
                                return None

See here:
http://gitorious.org/gnumed/gnumed/commit/e793017a2ff8ee5ec5c2c58d576fab2d1e0a607c

Holy shoot we are fast :-)

> 
> On my Mac, the result of the bash "env" command is
> ************************************
> (for user postgres) i
> 
> bash-3.2$ env
> SHELL=/bin/bash
> TERM=xterm-color
> USER=postgres
> SUDO_USER=djb
> SUDO_UID=503
> SSH_AUTH_SOCK=/tmp/launch-dt8zMb/Listeners
> __CF_USER_TEXT_ENCODING=0x0:0:0
> USERNAME=root
> PATH=/Library/PostgreSQL/8.4/bin:opt/local/bin:/opt/local/sbin:/opt/local/b
> in:/opt/local/sbin:/opt/local/bin:/opt/local/sbin:/opt/local/bin:/opt/local
> /sbin:/Library/Frameworks/Python.framework/Versions/Current/bin:/bin:/sbin:
> /usr/bin:/usr/local/bin:/usr/sbin PWD=/
> EDITOR=/usr/bin/edit
> LANG=en_CA.UTF-8

while this suggests something about UTF-8 is does not really help in this 
case.

Sebastian