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 1tsTll-002RPR-O5 for pgsql-general@arkaria.postgresql.org; Wed, 12 Mar 2025 21:37:41 +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 1tsTlk-00EGtw-7g for pgsql-general@arkaria.postgresql.org; Wed, 12 Mar 2025 21:37:40 +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 1tsTlj-00EGti-Bq for pgsql-general@lists.postgresql.org; Wed, 12 Mar 2025 21:37:39 +0000 Received: from fhigh-b8-smtp.messagingengine.com ([202.12.124.159]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tsTle-002WRC-2r for pgsql-general@lists.postgresql.org; Wed, 12 Mar 2025 21:37:38 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfhigh.stl.internal (Postfix) with ESMTP id DD78E25401C6; Wed, 12 Mar 2025 17:37:34 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-12.internal (MEProxy); Wed, 12 Mar 2025 17:37:34 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1741815454; x=1741901854; bh=J4qdhWZR71EDm9/nLORj9sH8r04OM/uN+r0rvmwc8zc=; b= IzZSfVjrlFqQdk9VcvSSX8roQCwBJNHUPAQ9TT5iboadPeIwL2jC+YZ4CJlnxN9j 5iJ7VuI7YpZo+76AzDMr75nYGoCorv2E5olBtBoVtBVsC3YiRd8BIABquj0MqNAD HvUZRdbi7EkUnMkOHZlZG7vc2sAY+NiDlm9Dan2t1NvqTyk++SRys/o6mmLzWDEG Xysq7CHChqYDqpwPwWCE3lYh+QWgsAutGk7hud0cUyjDCeDCzjBA9XP94glWcIky hV9mI7Eg60S0uYdx5XQxxQKdJW3Iuy92+c/yLAwf50bwDAN2EYeZE/1GZP8DeAwy PJtpO9AcB9ytJniGFqSubA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1741815454; x= 1741901854; bh=J4qdhWZR71EDm9/nLORj9sH8r04OM/uN+r0rvmwc8zc=; b=s b/pcik+FOMXIN4e0Vjue9yVrmrt+Z+ADdEYJuCjleBPNU43Foc3HXNAmpHzarmGp YhXYC6+RKdWzcLMExwKAPnBFW0CrGlsL77yt/2+yDk04hrXNNO/D6gdXUgMBrxYC nPyMxSX7tdNbfIAFR6olo9LP4xVMWACQnDO9GyzUhcqtajJMSVtIPirs+rtDPUhx TGeXqFaOsVlLx2E2cM0AzwTRn3qeNsP7iaAS2YAjALIbfftdNWsUPdqAmRRBhgJ8 VQyay6/FpLL+584ujexLq4C4BJNs8t/rPoLC/tgjDsdRhYn58CLOlkVTeUbADywd 6X4w39H6RPbpNRa/sMLfw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgdduvdeiudeiucetufdoteggodetrf dotffvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggv pdfurfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpih gvnhhtshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtkeertddt vdejnecuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvh gvrhesrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhepgfdufeekhfevfeel veeiueevhedvuddukeduvddvlefhueeuieejtdeuvdevvdeunecuffhomhgrihhnpehpoh hsthhgrhgvshhqlhdrohhrghenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhep mhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhmpd hnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhopehprghu lhdrfhhovghrshhtvghrsehgmhgrihhlrdgtohhmpdhrtghpthhtohepphhgshhqlhdqgh gvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 12 Mar 2025 17:37:33 -0400 (EDT) Message-ID: <7bbcbbf8-9a45-4e8e-aa49-ad18ac1bfe7d@aklaver.com> Date: Wed, 12 Mar 2025 14:37:33 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Moving from Linux to Linux? To: Paul Foerster Cc: Pgsql-General List References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> <9a8d92de-228c-43b0-b66c-c3390b41044a@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/12/25 13:55, Paul Foerster wrote: > Hi Adrian, > >> On 12 Mar 2025, at 21:26, Adrian Klaver wrote: >> >> A good summary of the glibc issue: >> >> https://wiki.postgresql.org/wiki/Locale_data_changes >> >> With distro information: >> >> https://wiki.postgresql.org/wiki/Locale_data_changes#What_Linux_distributions_are_affected > > I know the article, thanks. We needed a full reindex when upgrading from SLES 15.2 to 15.3. We're on 15.5 now, partly already on 15.6. Thank god, we didn't have that ugly database back then that we have now. But I see the next doomsday coming on the horizon. 🤣 What version of RH are you migrating to? > > Also, we try to get rid of the libc locale provider and switch to libicu, wherever possible. > > Cheers, > Paul -- Adrian Klaver adrian.klaver@aklaver.com