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

Поиск
Список
Период
Сортировка
От Manika Singhal
Тема Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
Дата
Msg-id CAB1XC2JEK9_6tP3yVQM17+iBDbcyYKW-02MFwXKS8+MPeLdV6Q@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows  (Ben Caspi <benc@aidoc.com>)
Ответы Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows
Список 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 по дате отправления: