Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows - Mailing list pgsql-bugs

From Pavel Stehule
Subject Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows
Date
Msg-id CAFj8pRAZji-X8XNvywiUTqJkQWzdCX7MjYsMpXqDNd1PUDcqoQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows  (Halil Han Badem <halilhanbadem@gmail.com>)
Responses Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows  (Halil Han Badem <halilhanbadem@gmail.com>)
List 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 by date:

Previous
From: Halil Han Badem
Date:
Subject: Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows
Next
From: Halil Han Badem
Date:
Subject: Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows