Thread: problem with localization

Hi,

I'm new to pgsql and have run into the first problem. I can't persuade pgsql
to localize (German). As far as I got the manual, pgsql should recognize the
users' environment variable like LC_NUMERIC etc. and adjust the output
accordingly. Unfortunately the output (using psql) is always the same: date
in iso format and numbers with decimal point instead of the required comma.
Pgsql has been compiled with locale enabled and I have made sure that the
environment variables are set correctly (de_DE@euro, I also tried de_DE).
What did I forget?

Thanks
Carsten

Carsten Grewe <DerReisende@schatzis.org> writes:
> I'm new to pgsql and have run into the first problem. I can't persuade pgsql
> to localize (German).

It sounds like you are setting the locale in psql's environment.  But
what you have to set is the server's locale.

Also, in recent releases LC_COLLATE and LC_CTYPE are locked down at
initdb time; you can't change them just by restarting the postmaster.

            regards, tom lane