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

Hi

st 15. 11. 2023 v 19:53 odesílatel Halil Han Badem <halilhanbadem(at)gmail(dot)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.

https://dba.stackexchange.com/questions/188837/postgresql-9-5-wont-start-after-windows-10-fall-update

Regards

Pavel