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

Thank you, Pavel. With the feature in the Locale Builder application, we
can create an MSI build. With your solution, an MSI build can be created
and easily configured later.
Thanks for the tip.

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, 15 Kas 2023 Çar, 22:19 tarihinde
şunu yazdı:

> Hi
>
> st 15. 11. 2023 v 20:10 odesílatel Halil Han Badem <
> halilhanbadem(at)gmail(dot)com> napsal:
>
>> Thank you Pavel. This is indeed a good solution if you have a few
>> servers. We have users in hundreds across all major cities in Turkey, and
>> each user is using our database on their dedicated server (we are
>> developing a desktop application). In this case, providing support for all
>> databases will be very challenging. We will document the solution you
>> mentioned and add it to our documentation.
>>
>
> maybe it can be scripted, automatized. If I remember correctly, one of my
> customers wrote a small application that did this.
>
> Sure - it is a workaround - dirty, but some clients can be fixed
> tomorrow.
>
>
>> Best regards.
>>
>>
>> Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, 15 Kas 2023 Çar, 22:03
>> tarihinde şunu yazdı:
>>
>>> 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
>>>
>>