Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows - Mailing list pgsql-bugs

From Manika Singhal
Subject Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
Date
Msg-id CAB1XC2JEK9_6tP3yVQM17+iBDbcyYKW-02MFwXKS8+MPeLdV6Q@mail.gmail.com
Whole thread Raw
In response to PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows  (Ben Caspi <benc@aidoc.com>)
Responses Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
List pgsql-bugs

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

pgsql-bugs by date:

Previous
From: "Hayato Kuroda (Fujitsu)"
Date:
Subject: RE: Disabled logical replication origin session causes primary key errors
Next
From: Avi Uziel
Date:
Subject: Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows