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

[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?

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/bin:/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
SHLVL=1
SUDO_COMMAND=/usr/bin/su postgres
HOME=/Library/PostgreSQL/8.4
LOGNAME=root
SUDO_GID=503
DISPLAY=/tmp/launch-KsveC4/org.x:0
_=/usr/bin/env

************************************
(for user root):

SHELL=/bin/sh
TERM=xterm-color
USER=root
SUDO_USER=djb
SUDO_UID=503
SSH_AUTH_SOCK=/tmp/launch-dt8zMb/Listeners
__CF_USER_TEXT_ENCODING=0x0:0:0
USERNAME=root
PATH=/bin:/sbin:/usr/bin:/usr/local/bin:/usr/sbin
PWD=/var/root
EDITOR=/usr/bin/edit
LANG=en_CA.UTF-8
SHLVL=1
SUDO_COMMAND=/bin/sh
HOME=/var/root
LOGNAME=root
SUDO_GID=503
DISPLAY=/tmp/launch-KsveC4/org.x:0
_=/usr/bin/env

************************************
(for my personal user account):
TERM_PROGRAM=Apple_Terminal
TERM=xterm-color
SHELL=/bin/bash
TMPDIR=/var/folders/rR/rRhuX5jzF8WCKfgoTie3Zk+++TQ/-Tmp-/
Apple_PubSub_Socket_Render=/tmp/launch-JyeIOY/Render
TERM_PROGRAM_VERSION=273
OLDPWD=/Library/PostgreSQL/8.4
USER=djb
COMMAND_MODE=unix2003
SSH_AUTH_SOCK=/tmp/launch-dt8zMb/Listeners
__CF_USER_TEXT_ENCODING=0x1F7:0:0
PATH=/Library/PostgreSQL/8.4/bin:opt/local/bin:/opt/local/sbin:/opt/local/bin:/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
SHLVL=1
HOME=/Users/djb
LOGNAME=djb
DISPLAY=/tmp/launch-KsveC4/org.x:0
SECURITYSESSIONID=250729
_=/usr/bin/env


-- Jim