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 1u5Ukf-001Jcx-4W for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Apr 2025 19:18:21 +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 1u5Ukd-00Fv6Q-3q for pgsql-bugs@arkaria.postgresql.org; Thu, 17 Apr 2025 19:18:19 +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 1u5Ukc-00Fv6I-RA for pgsql-bugs@lists.postgresql.org; Thu, 17 Apr 2025 19:18:19 +0000 Received: from elephant.ash.relay.mailchannels.net ([23.83.222.57]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1u5UkZ-000cNE-2X for pgsql-bugs@lists.postgresql.org; Thu, 17 Apr 2025 19:18:19 +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 4E9A62C421E; Thu, 17 Apr 2025 19:18:14 +0000 (UTC) Received: from pdx1-sub0-mail-a297.dreamhost.com (100-102-86-101.trex-nlb.outbound.svc.cluster.local [100.102.86.101]) (Authenticated sender: dreamhost) by relay.mailchannels.net (Postfix) with ESMTPA id DC0CB2C41EB; Thu, 17 Apr 2025 19:18:13 +0000 (UTC) ARC-Seal: i=1; s=arc-2022; d=mailchannels.net; t=1744917494; a=rsa-sha256; cv=none; b=ZOTUhzid5XZ7CuZHEHINIK5skr5jSzjxyML0vaXxQnM0L3IBWrfd7CY1pzHPvWumYAkKiP rV8L0vTKTrRYxoJ67IhxyXHT259L4y7xLhQa50USqG/QiXtnH34urd+DZLOd1l2PUps/qL qjClfNj6Q/0C2gNeiA1HoXVk6GOb2ZVzQDYHz7IL1fivtPqypuZ1/OXrC03056e0EF4wRu 48sUvb83wZIxaiSy+OZ/ty4o/ZMeGjsRDphc+VNIiA5yYxkd0XgsqKSfM6UnzT1ec22s3q r8S9VkZdaTEC5RCIq42TgM4OpA8YqZJ8UDix0Kv/ltGWysWV4ZTqMm63Ji3TLw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=mailchannels.net; s=arc-2022; t=1744917494; 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=rR9NvTNxdYSAz80ZqE+VhDt8bd/c2QzCTBK4wQbNQF8=; b=iIvKpveWk8b7WsXujy2uvqUJB+4MTo0KTdbqdGnZyjGp4DQhFqEqWBHw04Bu5Uq3jdNfew GOdxFeLUmbm3guxuUKAlkeYmfNKGmQd7jPWjScf7w9/XoQcbhgdUGfwgnlTa0hFPdgrQWz wWL8TJnTgCtE44AuF1njb0w1zrSR5l1ka9vrbCZR5CRlO4reGb/1g7XyqZTukF69DjAaJk 0tzsJFs68QFphofs5YMgFVIdN34vUQGjXinarCEdRnjjekjnk4PdH/17jaTCw0RRvGY080 r1jlup2/VGz4jYeDzQSkgQjCc70/OFwOlz74VeBUEDZixKNSDCFck+pi/+jISg== ARC-Authentication-Results: i=1; rspamd-77f95b8c6b-xjqsn; 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-Trade-Name: 2f90988154a9d7a2_1744917494194_3817552706 X-MC-Loop-Signature: 1744917494193:3336253532 X-MC-Ingress-Time: 1744917494193 Received: from pdx1-sub0-mail-a297.dreamhost.com (pop.dreamhost.com [64.90.62.162]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384) by 100.102.86.101 (trex/7.0.3); Thu, 17 Apr 2025 19:18:14 +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-a297.dreamhost.com (Postfix) with ESMTPSA id 4Zdnjc568kzFR; Thu, 17 Apr 2025 12:18:12 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cryptonector.com; s=dreamhost; t=1744917493; bh=rR9NvTNxdYSAz80ZqE+VhDt8bd/c2QzCTBK4wQbNQF8=; h=Date:From:To:Cc:Subject:Content-Type; b=uU6yNSlBahOR9CmVvSJw5OCa5vAwKbU/mbLpZJTgvJv569sTUWU+dTXXRna+8eS8Q g8Bux/zKWWQ8Ihbqm3aawnvyIPNWNWbTSYBqmsKQv6dDqwjRxGWAMU7QGXBnXMtt1U oGRiMPMnEFpwhQ84HiVd+m8hroCieRbLo/F/hXcG2ArQ3l3T7S5kkyHObDPt6omoQp ShcgYOGrkz12xroq8rrxP+hY18tPU0WdjYJL5gbh8KQOrtZSAxgwmbilzuK2JDP1mo ETI++XzdiMAlgjkMt0Gc+tYEeRzCRAj5+8Gdf+XXmt2HUzrKm5VzaD7Z/0RlmDQlV8 rZNk0fH4hcs6Q== Date: Thu, 17 Apr 2025 14:18:10 -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 12:34:29PM +1200, Thomas Munro wrote: > [...]. Non-UTF-8 text does seem to be almost extinct in the > wild now... *except* on Windows. I think/hope that will eventually Sigh, yes. > change too, you can see it starting... [...] Yes, MSFT devs seem keen to push the UTF-8 codepage, which is a most welcome development. > https://www.postgresql.org/message-id/flat/CA%2BhUKGLrx02%3DwT647oYz7x0GW%3DPyQdma0s4U6w9h%3DsuFjcciTw%40mail.gmail.com I replied. 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. Nico --