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

In this case, the service starts, but you cannot establish a connection to
the database. In other words, it gives the following error. This error is
expected because the database was created with Turkish_Turkey.1254. Due to
the name change to Turkish_Türkiye.1254, it cannot find the local name.

failed: FATAL: database locale is incompatible with operating system
DETAIL: The database was initialized with LC_COLLATE "Turkish_Turkey.1254",
which is not recognized by setlocale(). HINT: Recreate the database with
another locale or install the missing locale.

Regards,
Halil Han.

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, 15 Kas 2023 Çar, 21:29 tarihinde
şunu yazdı:

> On Wed, 2023-11-15 at 21:11 +0300, Halil Han Badem wrote:
> > 7. Later, in the Windows Event Logs, you will see the error
> > "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.
>
> If you edit "postgresql.conf" and change all occurrences of
> "Turkish_Turkey.1254"
> to "Turkish_Türkiye.1254", can you start the service?
> If yes, can you connect to a Turkish database?
>
> Yours,
> Laurenz Albe
>