Re: BUG #15772: Some messages in log files are in ANSI encoding while server encoding is UTF8 - Mailing list pgsql-bugs

From Eugene Podshivalov
Subject Re: BUG #15772: Some messages in log files are in ANSI encoding while server encoding is UTF8
Date
Msg-id CAEPw1JVtaxdh+BYkYL+G4aNzw3nbuK3sj6cW6xKk-aZAqWFkrw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #15772: Some messages in log files are in ANSI encodingwhile server encoding is UTF8  (Bruce Momjian <bruce@momjian.us>)
Responses Re: BUG #15772: Some messages in log files are in ANSI encodingwhile server encoding is UTF8  (Bruce Momjian <bruce@momjian.us>)
Re: BUG #15772: Some messages in log files are in ANSI encodingwhile server encoding is UTF8  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-bugs
Bruce,
Here is a screenshot of how looks like when I open the log file in notepad++ and switch encoding from UTF8 to ANSI.
image.png

Regards,
Eugene

чт, 18 апр. 2019 г. в 17:31, Bruce Momjian <bruce@momjian.us>:
On Thu, Apr 18, 2019 at 01:53:18PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference:      15772
> Logged by:          Eugene Podshivalov
> Email address:      yaugenka@gmail.com
> PostgreSQL version: 11.2
> Operating system:   Windows 10
> Description:       
>
> My postgresql.conf has the following locale settings
> ----
> #client_encoding = sql_ascii          # actually, defaults to database encoding
>
> # These settings are initialized by initdb, but they can be changed.
> lc_messages = 'Russian_Russia.1251'                   # locale for system error message
> strings
> lc_monetary = 'Russian_Russia.1251'                   # locale for monetary formatting
> lc_numeric = 'Russian_Russia.1251'                    # locale for number formatting
> lc_time = 'Russian_Russia.1251'                               # locale for time formatting
> ----
> Server encoding is "UTF8".
> Messages in the log file are usually in UTF8, but some messages are logged
> in ANSI encoding.
> Here are some example cases (in the Russian language)  when ANSI is used
> instead of UTF8
> --
> СООБЩЕНИЕ:  контрольные точки происходят слишком часто (через 19 сек.)
> ПОДСКАЗКА:  Возможно, стоит увеличить параметр "max_wal_size".
> --
> СООБЩЕНИЕ:  получен запрос на быстрое выключение
> СООБЩЕНИЕ:  прерывание всех активных транзакций
> --
> СООБЩЕНИЕ:  система БД была выключена:
> СООБЩЕНИЕ:  система БД готова принимать подключения

I am kind of confused since all the messages look like Russian to me,
except for the mention of "max_wal_size".  When you say ANSI, do you
mean ISO-8859-5 - Cyrillic, or ASCII?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +
Attachment

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #15772: Some messages in log files are in ANSI encodingwhile server encoding is UTF8
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #15772: Some messages in log files are in ANSI encodingwhile server encoding is UTF8