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

From Avi Uziel
Subject Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
Date
Msg-id CAMjTNpuzQQaH7PoOOLmhDDH050GHaNazw4PMSrZnEx-EYpqEpQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows  (Manika Singhal <manika.singhal@enterprisedb.com>)
Responses Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
List pgsql-bugs
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.singhal@enterprisedb.com> wrote:

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: Manika Singhal
Date:
Subject: Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
Next
From: Robert Treat
Date:
Subject: Re: BUG #18900: Missing RPM python3-kazoo for RHEL9 - patroni RPM cannot be installed