Re: BUG #15772: Some messages in log files are in ANSI encoding while server encoding is UTF8

From: Eugene Podshivalov <yaugenka(at)gmail(dot)com>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15772: Some messages in log files are in ANSI encoding while server encoding is UTF8
Date: 2019-04-18 14:40:59
Message-ID: CAEPw1JVtaxdh+BYkYL+G4aNzw3nbuK3sj6cW6xKk-aZAqWFkrw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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: image.png]

Regards,
Eugene

чт, 18 апр. 2019 г. в 17:31, Bruce Momjian <bruce(at)momjian(dot)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(at)gmail(dot)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(at)momjian(dot)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 +
>

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2019-04-18 15:29:38 Re: BUG #15772: Some messages in log files are in ANSI encoding while server encoding is UTF8
Previous Message Bruce Momjian 2019-04-18 14:31:11 Re: BUG #15772: Some messages in log files are in ANSI encoding while server encoding is UTF8