| From: | Avi Uziel <avi(dot)uziel(at)aidoc(dot)com> |
|---|---|
| To: | Nico Williams <nico(at)cryptonector(dot)com> |
| Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, Manika Singhal <manika(dot)singhal(at)enterprisedb(dot)com>, Ben Caspi <benc(at)aidoc(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, Liran Amrani <lirana(at)aidoc(dot)com>, Shahar Amram <shahara(at)aidoc(dot)com>, Sandeep Thakkar <sandeep(dot)thakkar(at)enterprisedb(dot)com>, tgl(at)sss(dot)pgh(dot)pa(dot)us |
| Subject: | Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows |
| Date: | 2025-04-22 10:58:06 |
| Message-ID: | CAMjTNpt0GNgmf6PEbriTqAdWXcUmnJZntB4Hp=n_aVD=RsBEHw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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
On Thu, Apr 17, 2025 at 10:31 PM Nico Williams <nico(at)cryptonector(dot)com>
wrote:
> On Thu, Apr 17, 2025 at 02:18:10PM -0500, Nico Williams wrote:
> > What I might consider is to require that all new PG DBs must run in
> > UTF-8 locales and/or codepages only, and provide a migration tool for
> > existing DBs while not breaking them.
>
> And declare that PG 19 or 20 will not support non-UTF-8 locales /
> codepages.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hayato Kuroda (Fujitsu) | 2025-04-22 11:00:51 | RE: Disabled logical replication origin session causes primary key errors |
| Previous Message | PG Bug reporting form | 2025-04-22 09:38:45 | BUG #18900: Missing RPM python3-kazoo for RHEL9 - patroni RPM cannot be installed |