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.
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?
