Date: Thu, 17 Apr 2025 14:31:02 -0500
From: Nico Williams <nico@cryptonector.com>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>,
	Avi Uziel <avi.uziel@aidoc.com>,
	Manika Singhal <manika.singhal@enterprisedb.com>,
	Ben Caspi <benc@aidoc.com>, pgsql-bugs@lists.postgresql.org,
	Liran Amrani <lirana@aidoc.com>, Shahar Amram <shahara@aidoc.com>,
	Sandeep Thakkar <sandeep.thakkar@enterprisedb.com>,
	tgl@sss.pgh.pa.us
Subject: Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on
 Windows
Message-ID: <aAFW9my7HtKjNA71@ubby>
References: 
 <CABv1Mx6uBG1OJX3+FHewqCoGtGuQqsLniB47WUrrt8sd1PDK1Q@mail.gmail.com>
 <CAB1XC2KYtPk1h-nopnq3nQMNAG8knA419WozrzSPnkT9LyOfNA@mail.gmail.com>
 <CAMjTNpvFL8P3Y_gdoY_K-f8RbPd3KLNF_8v_Gf5u4HkJ=g3gGQ@mail.gmail.com>
 <a5eefdf4ff9d38c1eb4d4a1e4e4984b386a71218.camel@cybertec.at>
 <CA+hUKGKcbtDSvTySZgmpm2GyzBwTKnEQsaYpgbT6zw0-1qLz6Q@mail.gmail.com>
 <Z/6E91nSacY/8zj1@ubby>
 <CA+hUKGKtbcF-cF__hbx3Cixzp2iPoBAy+9OtQFMhuy3nuF0f-A@mail.gmail.com>
 <Z/7QqnX3R9s+te4O@ubby>
 <CA+hUKGJZGBnATo4-hci-ZoDTLrXWjYT0ZS8_F2XirQ8+Nc1RHg@mail.gmail.com>
 <aAFT8lYzVNax7VO+@ubby>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <aAFT8lYzVNax7VO+@ubby>
Archived-At: <https://www.postgresql.org/message-id/aAFW9my7HtKjNA71%40ubby>
Precedence: bulk

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.