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

On Tue, Apr 22, 2025 at 4:28 PM Avi Uziel <avi.uziel@aidoc.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