Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSvl3-0007Wb-FM for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Feb 2023 08:06:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pSvl2-00023j-8L for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Feb 2023 08:06:16 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pSvl1-00023a-Uv for pgsql-hackers@lists.postgresql.org; Fri, 17 Feb 2023 08:06:15 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pSvkw-0002vb-No for pgsql-hackers@postgresql.org; Fri, 17 Feb 2023 08:06:15 +0000 Received: by mail-pj1-x102a.google.com with SMTP id i10-20020a17090a7e0a00b002341a2656e5so377298pjl.1 for ; Fri, 17 Feb 2023 00:06:10 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20210112.gappssmtp.com; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=ffOtvTP5G2BXYT1la2s81aTaNQsAba4PvoWnU44qpk0=; b=SeNM5DyMxWP+pSi0wum8nMx1qtJ6/bPoAzLHpsXNV4SFoYCnWGr0Ee94X8V02okN7A fuGUrmRjY7HfhY3221xCy2pEPviggk+6W0X1XG1as/CbXtY+cF3X1AEHqy2wyTFYZiNh 6tCkZJ1RVPLyrNoTb9yRRijjTaNSaOxgCK97eenF8UGedE0ZKGs5L6GnxR5tbyrf7S1s UDEtVsB5TGQWX8NO8edjKGBma52U00ah/4kmuBaGxjJzqDGehI8SwDkhJXgbi50Byy7K iZ96Zb1MEBJcmRDPjcNeSpnsJ6u4ANiLC/3qLX8Uu3Ib/h+eJWTjuBff0Zz9xhYGUfvD BFwA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=ffOtvTP5G2BXYT1la2s81aTaNQsAba4PvoWnU44qpk0=; b=E1Bb71ODT0Idd+ftEcdFaZuI0os5faH54UtevBtq6rh06MceyESJ8ca/+H82fW+lKk RxbcRimL21FmNzrBHNlpw/7eye2iTqV7Ajdq0ZvZphGH+g/ETw7b+xXXBMxLv8p6HxJY qjNd5niDxRxKJmuLD5ca500wnmTzAf0ulbSkTffveMLqz+5NHiFg/pTetjRJqIawUc7u IjHf/a2N+R+r6J1GtCmrj2e3xjDkyXSymprqVUNScIWZWUw2USDZlSzcPhIIraqDx5dl ttTFnxJAswP27gtaEgaGdDLs1ylHLUDjryQKDlmQBReypthiw2CmSVJ4cHE/DrtU3L3n dboQ== X-Gm-Message-State: AO0yUKVtpt2xFtjYFciZKInnSsWvTde6YYhHhwojzJGaUUa3bMSiiFe0 69iImVlNdSqJBST401aQbpSzGQ== X-Google-Smtp-Source: AK7set+2kwD3Gn0d5guLIPIi/5ZI27TSziR0THaXMt/S7h+DllCmgOQzCeWn22oq26EwKXpCmaEC6g== X-Received: by 2002:a17:902:ec81:b0:19a:f556:e3b6 with SMTP id x1-20020a170902ec8100b0019af556e3b6mr5858921plg.32.1676621167984; Fri, 17 Feb 2023 00:06:07 -0800 (PST) Received: from jeff-laptop.lan (c-73-231-146-4.hsd1.ca.comcast.net. [73.231.146.4]) by smtp.gmail.com with ESMTPSA id x7-20020a170902a38700b0019472226769sm2503217pla.251.2023.02.17.00.06.07 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 17 Feb 2023 00:06:07 -0800 (PST) Message-ID: Subject: Re: Move defaults toward ICU in 16? From: Jeff Davis To: Andres Freund Cc: Tom Lane , Thomas Munro , Robert Haas , pgsql-hackers@postgresql.org Date: Fri, 17 Feb 2023 00:06:06 -0800 In-Reply-To: <20230214175957.idkb7shsqzp5nbll@awork3.anarazel.de> References: <510d284759f6e943ce15096167760b2edcb2e700.camel@j-davis.com> <1590310.1675379449@sss.pgh.pa.us> <337d581bae5d6253919f70acdfc184631f0ad41b.camel@j-davis.com> <20230209022234.gihj4apas6ycaddq@awork3.anarazel.de> <5ffeafe843d43a975f31479fbd211ab88404841b.camel@j-davis.com> <20230211020042.uthdgj72kp3xlqam@awork3.anarazel.de> <20230214175957.idkb7shsqzp5nbll@awork3.anarazel.de> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.44.4-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, 2023-02-14 at 09:59 -0800, Andres Freund wrote: > I am saying that pg_upgrade should be able to deal with the > difference. The > details of how to implement that, don't matter that much. To clarify, you're saying that pg_upgrade should simply update pg_database to set the new databases' collation fields equal to that of the old cluster? I'll submit it as a separate patch because it would be independently useful. Regards, Jeff Davis