Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4nuY-007YSL-KF for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Apr 2025 21:33:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1u4nuW-00HWOg-Bv for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Apr 2025 21:33:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u4nuV-00HWOX-TF for pgsql-bugs@lists.postgresql.org; Tue, 15 Apr 2025 21:33:40 +0000 Received: from poodle.tulip.relay.mailchannels.net ([23.83.218.249]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u4nuS-000HTl-3D for pgsql-bugs@lists.postgresql.org; Tue, 15 Apr 2025 21:33:40 +0000 X-Sender-Id: dreamhost|x-authsender|nico@cryptonector.com Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id 77E544202D; Tue, 15 Apr 2025 21:33:35 +0000 (UTC) Received: from pdx1-sub0-mail-a228.dreamhost.com (trex-6.trex.outbound.svc.cluster.local [100.110.51.113]) (Authenticated sender: dreamhost) by relay.mailchannels.net (Postfix) with ESMTPA id 671074322A; Tue, 15 Apr 2025 21:33:34 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1744752814; a=rsa-sha256; cv=none; b=BAyjglEjTVfkq3ujoivQymI/3ZLxoBZjX8/yL2fhqqBue8BPkjjt8KlTO2bsWCo+7d/U/T KTN1HXrYFiLSi8+Kx8eVYpdSkyteG94jTwv/svgkZZ/lkIiZoQuOWbNNpFJeQyFHZUGGzI E/+s0ZlJbL9a3vv21muxoLhOOLRKKsP/1JcdsNwPfrveyaj8gdbVZCiuKLPQUMDtZcNV1H 8fzOKhWHfqKNhso4+ztYkqIRF8EoHRMs4qT3kVVe33vyQIatZFIHiA+chMjVUMRWw2FPXB /ZJ6O4UXSys4pTB7Tikuj9NsPVqxg9nNlLQedgoP28sdSD0uQN4x7CL91JOahg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1744752814; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references:dkim-signature; bh=XToOISkMLPEphXtU+9EvYabtXWywqxjMxCZNbl8cJSs=; b=As+VORzv0m8kv3RTbnN+WMT9GVsfUxIUEMR5NTU1iD4dXtIMETdTJKpzjIXmG4DCDUnhJ6 TinSXY9i2cA+RVn5ztxymqqpDgLDVFctomlmUnqwi3KamzTQ34RqIROcBXAFZ2TZ9MuJUt MCJ/n5knVeGLxC6wHXPWw1UqVsO1sw2FknVgmumQzCoeVhaQ7O73E/bijDRgeDZiI4WId6 3HcFCcuo/65sUscLlXT7ZIi6UA7mw3zM44zscrH7t8OxAjnDrNWRJxR3xGOvEal6oGfZ5t wReKQFLHo6bdrlSGBGZ3K4I8vbHFBhZN6Y5+6dJKMY1tnsJ94FZdFNK74gNjEw== ARC-Authentication-Results: i=1; rspamd-5dd7f8b4cd-wvtg7; auth=pass smtp.auth=dreamhost smtp.mailfrom=nico@cryptonector.com X-Sender-Id: dreamhost|x-authsender|nico@cryptonector.com X-MC-Relay: Neutral X-MailChannels-SenderId: dreamhost|x-authsender|nico@cryptonector.com X-MailChannels-Auth-Id: dreamhost X-Tasty-Tart: 46b516727ffc745f_1744752815153_3260955183 X-MC-Loop-Signature: 1744752815153:3961256217 X-MC-Ingress-Time: 1744752815152 Received: from pdx1-sub0-mail-a228.dreamhost.com (pop.dreamhost.com [64.90.62.162]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.110.51.113 (trex/7.0.3); Tue, 15 Apr 2025 21:33:35 +0000 Received: from ubby (syn-075-081-095-064.res.spectrum.com [75.81.95.64]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) (Authenticated sender: nico@cryptonector.com) by pdx1-sub0-mail-a228.dreamhost.com (Postfix) with ESMTPSA id 4Zccph6KNkzFb; Tue, 15 Apr 2025 14:33:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cryptonector.com; s=dreamhost; t=1744752813; bh=XToOISkMLPEphXtU+9EvYabtXWywqxjMxCZNbl8cJSs=; h=Date:From:To:Cc:Subject:Content-Type; b=kt00llGKIticza/BhMPjjhvUV2nmfczUACkxFyip7bHMjw15ZIukTREJdRIM//lFy jm007D+gt6+gR6OPJfpLrZ6/Nok3cOsYW10supwPHbePWR5Ucyaa00R7PM8HS3ot/2 S/6oaNGP8e6aJT/QpTz2hJ7++r51BMAt6HPQ8I5Hjv0kSK3klJNsc2NykZFkX9UyVu HTlVKmo/Z1MpXqP8jIwpnY13uNugSTngw1j037yRxPdkiSn3GYEQCVORWa8HXFkhY9 B6V6HUDvFc0tf7UZTqay2btwv2zu7sb3PwSmA2IUeqcDa3e4wTkjV+IY+ZpW0HJS1U NXkG8ZfpDWNiw== Date: Tue, 15 Apr 2025 16:33:30 -0500 From: Nico Williams To: Thomas Munro Cc: Laurenz Albe , Avi Uziel , Manika Singhal , Ben Caspi , pgsql-bugs@lists.postgresql.org, Liran Amrani , Shahar Amram , Sandeep Thakkar , tgl@sss.pgh.pa.us Subject: Re: PostgreSQL v15.12 fails to perform PG_UPGRADE from v13 and v9 on Windows Message-ID: References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 16, 2025 at 09:11:02AM +1200, Thomas Munro wrote: > We're not talking about designing anything of our own or embedding > BCP-47 knowledge into PostgreSQL, we're just agreeing to encourage > Windows users to prefer the OS's modern locale names over its ancient > ones in our tooling. We merely pass the strings around and hope they > still work. We've been referring to its modern naming system as > BCP-47, though sure, you're right, they're "BCP-47 based". Ah, then my apologies for the noise.