Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows

Thanks!

I was able to use "--locale en-US" using Windows installer 15.12.
So it is supported, just not supporting the "locale long name format"?

Feel free to send us the test installer, we will be happy to assist.

Avi

On Tue, Apr 22, 2025 at 2:30 PM Manika Singhal <
manika(dot)singhal(at)enterprisedb(dot)com> wrote:

>
> On Tue, Apr 22, 2025 at 4:28 PM Avi Uziel <avi(dot)uziel(at)aidoc(dot)com> wrote:
>
>> Hi,
>>
>> I'm struggling with the upgrade process related to this issue, and I hope
>> you can help me.
>>
>> As mentioned at the beginning of this thread, I'm trying to upgrade
>> cluster version 13.13 to 15.12 on Windows.
>> My v13.13 cluster uses "English_United States.1252" locale.
>>
>> When I install the new cluster v15.12, on Windows using the CLI command,
>> I would like to pass this locale using the "--locale" flag.
>> This way, the "old" and "new" clusters will have the same locale, and the
>> "pg_upgrade" will work.
>>
>> The issue is that running the installed using "--locale 'English_United
>> States.1252'" fails with an error "locale specified not supported".
>> Can you please clarify this for me?
>>
>> Thanks,
>> Avi
>>
>
> Hi Avi,
>
> The `--locale` option is not yet supported by the Windows installers.
>
> As an alternative, you can download the latest *15.12-2* installer from
> the website
> and proceed with the installation using *GUI* instead of the command line.
> During the installation, you will be presented with a locale selection
> list in both formats
> (BCP codes followed by long names). Please select *"English, United
> States"* at that time
> and you'll be all set.
>
> JFYI, the upcoming minor releases, scheduled on 8th May, will include
> support for `--locale`
> option. If you are interested, we'd be happy to share a *test-installer*
> with you that includes this feature.
>
> Let us know!
>
> Thanks!
> Manika Singhal
> EDB India
>