[Pkg-postgresql-public] Bug#700271: Bug#700271: postgresql-9.1: non-obvious choice of database locale

Helmut Grohne helmut at subdivi.de
Thu Feb 14 09:53:57 UTC 2013

Control: reopen -1
Control: retitle -1 mention database encoding used during installation
Control: tags -1 - wontfix

On Wed, Feb 13, 2013 at 11:14:01AM +0100, Martin Pitt wrote:
> Sure, set LANG=de_DE.UTF-8 and LC_MESSAGES=C . That will still use
> UTF-8 character encoding/sorting (LC_CTYPE, LC_COLLATE), and region
> settings (LC_PAPER, LC_TIME, LC_PAPER, etc.), but display the plain C
> (untranslated) strings.

Thanks. I tried this, but it appears to have unintended side effects.
For instance I really expect LC_COLLATE=C when using sort or sed. I am
similarly accustomed to LC_TIME=C by now. Scripts not expecting non-C
locales used to be frequent issues in Debian, but still are for my
personal scripts.

I also noticed that the pg_createcluster(8) is quite precise on the
locale settings used. This is great. Do you think that having the locale
preseedable[1] would be a worthwhile feature? I could not find out
whether the locale settings are used when installing packages via "d-i
pkgsel/include string".

> Agreed, thanks!

Metadata updated.


[1] http://wiki.debian.org/DebianInstaller/Preseed

More information about the Pkg-postgresql-public mailing list