Feedback-ID: i76984098:Fastmail
Message-ID: <88e330d0-907b-404c-9ec4-4d8a58bbb1a2@aklaver.com>
Date: Mon, 22 Jul 2024 12:56:39 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Windows installation problem at post-install step
To: =?UTF-8?B?RXJ0YW4gS8O8w6fDvGtvZ2x1?= <ertan.kucukoglu@gmail.com>
Cc: pgsql-general@lists.postgresql.org
References: <CAH2i4ydECHZPxEBB7gtRG3vROv7a0d3tqAFXzcJWQ9hRsc1znQ@mail.gmail.com>
 <CAH2i4yfkH7YPoLz1aE6MQiBOm8dra5uOTpn51=9ce_Tm6fy3Pw@mail.gmail.com>
 <a9c619c4-f681-4e28-b1d0-cb4845e06fe8@aklaver.com>
 <CAH2i4ycV8p_uDsdGRcP3bWcU52ogojg9_-mT8uMixSqpNmW7Sg@mail.gmail.com>
 <d55c35b9-a658-4961-849e-871e7dd23fe9@aklaver.com>
 <CAH2i4yfBEYmOzsvsT=D+ySpLpsEW2O1VfUwx9Ckd69du67YY_w@mail.gmail.com>
 <44b44ece-dce6-4b4f-b751-8787a5a071e0@aklaver.com>
 <CAH2i4yc9o6wVoA4Bc07YxaH4=FKkhLJYHXOUqWsupO1uLEKJFg@mail.gmail.com>
 <011a5254-4abb-460b-bd02-92e8dfc0e5ea@aklaver.com>
 <CAH2i4yeB3LR0xoNVg5=9c3CaBN3MgA5GTqDSk155e6fvD+a7FA@mail.gmail.com>
 <9cc12221-ba75-4ba0-803f-51be5c8f1525@aklaver.com>
 <CAH2i4yde0Y1Xjqw8PgexiqyB7nqD51JWQF-i+RUVmmsZattB2g@mail.gmail.com>
 <4c21a115-ec58-4e79-86b8-8626bd307e02@aklaver.com>
 <CAH2i4ydwvth001buCV662cd8iMR1RdKMYPBuziTh08aHhuE06w@mail.gmail.com>
 <34aefaae-7c57-4593-af82-8c83eb31f3ec@aklaver.com>
 <CAH2i4ye5O2LFVy8kYA_Ws+4QBXDXMyKuwYQr2rMLudQeuq9fng@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAH2i4ye5O2LFVy8kYA_Ws+4QBXDXMyKuwYQr2rMLudQeuq9fng@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/88e330d0-907b-404c-9ec4-4d8a58bbb1a2%40aklaver.com>
Precedence: bulk

On 7/22/24 11:48, Ertan Küçükoglu wrote:
> Adrian Klaver <adrian.klaver@aklaver.com 
> <mailto:adrian.klaver@aklaver.com>>, 22 Tem 2024 Pzt, 21:10 tarihinde 
> şunu yazdı:
> 
>     I am getting out of my depth here, but I am pretty sure that:
> 
>     ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'Turkish_Turkey.1254'
> 
>     is not going to work. That you will need to change the locale to a
>     Turkish UTF8 name.
> 
> 
> I added tr_TR.UTF-8 to the system locales.
> I also changed all Turkish_Turkey.1254 to tr_TR.UTF-8 in the dump file.
> Unfortunately, I found that there are some databases created using 
> WIN1254 encoding.
> I do not know what I should do with them. I don't think simply changing 
> WIN1254 -> UTF8 will work.
> I will probably wait for a working Windows installer.

 From previous post of yours:

"I was also hit by that OS update.
There is a Microsoft tool for creating a locale installer
https://www.microsoft.com/en-us/download/details.aspx?id=41158
Using that tool and adding a second locale Turkish_Turkey.1254 (name before
Microsoft update) in the OS can fix your broken PostgreSQL.
I believe most people simply choose this path.
There are also several blogs/articles written in Turkish about the problem."

Why not use that?

> 
> Thanks & Regards,
> Ertan

-- 
Adrian Klaver
adrian.klaver@aklaver.com