Re: logfile character encoding - Mailing list pgsql-general

From Redoute
Subject Re: logfile character encoding
Date
Msg-id 53F0845C.8090802@tortenboxer.de
Whole thread Raw
In response to Re: logfile character encoding  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: logfile character encoding  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Am 16.08.2014 21:40, schrieb Tom Lane:

> You need to make sure the postmaster's
> environment selects a UTF8 locale.

So is this possible at all in Windows?
http://msdn.microsoft.com/en-us/goglobal/bb896001.aspx
According to this table Locales support ANSI and OEM codepages, but
there is no mention of Unicode encodings. Don't know what ANSI codepage
"0" or OEM codepage "1" means, anyway this is not given for german or
english language.

I tried to change the lc_messages configuration variable in
postgresql.conf. Setting has been

> # These settings are initialized by initdb, but they can be changed.
> lc_messages = 'German_Germany.1252'            # locale for system error message

I tried to change it to German_Germany.UTF-8, which caused a fallback to
english messages. May be because the value is invalid at all, or may be
because there are no translations for this locale. (BTW having messages
in english seems to be a usable work-around, since these messages are
ASCII only. It is also possible to manually set lc_messages back to
'German_Germany.1252' per session, so that the logfile contains english
messages from the "postmaster" and UTF-8 encoded german messages from
the sessions. But would this be a solution for default Windows
installations?)

Thank you,
Redoute


pgsql-general by date:

Previous
From: Chris Hanks
Date:
Subject: Re: Support functions for GiST index on citext
Next
From: Adrian Klaver
Date:
Subject: Re: logfile character encoding