Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows
Дата
Msg-id CAFj8pRAZji-X8XNvywiUTqJkQWzdCX7MjYsMpXqDNd1PUDcqoQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows  (Halil Han Badem <halilhanbadem@gmail.com>)
Ответы Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows  (Halil Han Badem <halilhanbadem@gmail.com>)
Список pgsql-bugs
Hi

st 15. 11. 2023 v 19:53 odesílatel Halil Han Badem <halilhanbadem@gmail.com> napsal:
I can convey it to you in more detail. Now I will explain the steps to avoid repeating this error.

1. Obtain a Windows version prior to version 22H2 22621.2715.
2. During the PostgreSQL installation in that version, choose Turkish, Turkey as the locale (during installation).
3. Create a database using PgAdmin or any other tool and select Turkish_Turkey.1254 as the local option.
4. Update your operating system to version 22H2 22621.2715.
5. After updating the operating system and restarting, you will notice that the PostgreSQL service is not running.
6. When you try to start the service, you will encounter an error stating that the Windows service cannot be started.
7. Later, in the Windows Event Logs, you will see the error "2023-11-15 10:47:14.877 +03 [1644] FATAL: configuration file "C:/Program Files/PostgreSQL/15/data/postgresql.conf" contains errors."
8. The cause of the error in this file is the values specified as lc_messages, lc_monetary, lc_numeric, lc_time under Turkish_Turkey.1254. This is because, with the new update, Turkish_Turkey.1254 is no longer present in the Windows operating system; the correct locale name is now Turkish_Türkiye.1254.

This is a similar issue to rename the Czech locale "Czech_Czech Republic.1250" to "Czech_Czechia.1250" six years ago.


Regards

Pavel

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Halil Han Badem
Дата:
Сообщение: Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows
Следующее
От: Halil Han Badem
Дата:
Сообщение: Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows