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

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 (view raw or flat)
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

pgsql-admin by date

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

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