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 |
| Дата | |
| Msg-id | CA+hfYg88ofsY8oknYiQmuc_3jiYu1kMVnJwY4=bE10+FYpG+Tg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows
Re: BUG #18196: Databases Created in Turkish Language Will Not Run on the Latest Version of Windows |
| Список | pgsql-bugs |
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,
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.albe@cybertec.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
В списке pgsql-bugs по дате отправления: