Re: Postgresql 8.1.3 Debian installation encoding question

From: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org, Debian users <debian-user(at)lists(dot)debian(dot)org>
Subject: Re: Postgresql 8.1.3 Debian installation encoding question
Date: 2006-03-26 09:37:58
Message-ID: 1143365878.7278.6.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, 2006-03-26 at 10:20 +0200, Peter Eisentraut wrote:
> It's derived from the locale, so make sure all your locales are set up
> correctly.
OK, but how is it derived? As far as I know, I did not change anything
in the locales since the previous time I installed PostgreSQL.

My locales are:
jkr(at)panoramix:~$ locale
LANG=
LANGUAGE=en_US:en_GB
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

I solved the immediate "problem" by doing an "initdb -E UTF8" but I am
not quite satisfied by that sollution: it makes the installation of
PostgreSQL more difficult for non-initiated users (including myself),
who think that a simple "apt-get install' does the right thing.

TIA

Joost

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Donald Fraser 2006-03-26 15:58:20 Initial request packet for SSL
Previous Message Erwin Brandstetter 2006-03-26 09:16:56 Re: database locale and system locale