Skip site navigation (1) Skip section navigation (2)

Re: server/db encoding (mix) issues

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jan-Peter(dot)Seifert(at)gmx(dot)de
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: server/db encoding (mix) issues
Date: 2008-09-08 09:40:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Jan-Peter(dot)Seifert(at)gmx(dot)de wrote:
> Well - I did setup two instances of 8.3.3 on an Ubuntu 7.10 system last week - both under a different user account. I set the locale for each account in the .bashrcs ("export LANG=de_DE" and "export LANG=de_DE.UTF-8" respectively). After that I ran initdb ("initdb --encoding='LATIN1' -W -A md5 -D $PGDATA" and "initdb --encoding='UTF8' -W -A md5 -D $PGDATA"(?)). I'm not sure whether I specified the server encoding for the UTF8-instance though. Did I make something wrong?

Not really, but I suggest you forget about the environment settings and 
forget about the --encoding option and just use the --locale option of 
initdb to set the locale settings.

> However, when I try to create an UTF-8 db in the LATIN1 server or an LATIN1 db in the UTF-8 server I get the error that the db encoding does not match the server locale and that the LC_TYPE-Locale requires the encoding of the server. Before that I thought it just fails because there is no locale with the name LATIN1 in windows. Are those additional encoding checks in v8.3.3 or had they been put in place with v8.3.1 already? 

They have existed since 8.3.0.

In response to

pgsql-admin by date

Next:From: Jan-Peter.SeifertDate: 2008-09-08 10:05:27
Subject: Re: pg_dump etc. versions
Previous:From: Jan-Peter.SeifertDate: 2008-09-08 08:57:58
Subject: Re: server/db encoding (mix) issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group