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 1tsT7v-002KJw-So for pgsql-general@arkaria.postgresql.org; Wed, 12 Mar 2025 20:56:31 +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 1tsT7u-00DbB7-0e for pgsql-general@arkaria.postgresql.org; Wed, 12 Mar 2025 20:56:30 +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 1tsT7t-00DbAb-LW for pgsql-general@lists.postgresql.org; Wed, 12 Mar 2025 20:56:29 +0000 Received: from mail-wr1-x42e.google.com ([2a00:1450:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tsT7o-002W7b-2k for pgsql-general@lists.postgresql.org; Wed, 12 Mar 2025 20:56:28 +0000 Received: by mail-wr1-x42e.google.com with SMTP id ffacd0b85a97d-390fdaf2897so250720f8f.0 for ; Wed, 12 Mar 2025 13:56:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1741812985; x=1742417785; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=EoRFebr8Z5/PFZjx58wayxW/Jl5l91oiTu7CyQLjdRA=; b=I29by1U4gG+AYX44AUlM+mT0KYUO7ZUqauvBa1cTxzmkZZtHV+rxgSECdtCWsEYE8G 7raGTpYjRsVh5LyeGIhaKU6yHf6bKTbxOGBwlPyIJF0a22zZp+pwOYlmALGj6YuAaXpf IM+kk9heNpzPvIahzNwNjHTz3dXQCLTp1DyymIPb29NhFt5BmmfmnIPD1M5kmbPix4RQ 9vX3yCMSyuch4t8q2cUy4OWTDKBk5mbmkpavEe4eKys7UdlryBRFso+zSFpJfrmf/QNq EZ+UarxjHTOKyi0JlYyBTAjosV/MIvrgyteC2i9yo6BTs33fXQZl7TO1CRE+R7HxO+hY n7cQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1741812985; x=1742417785; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=EoRFebr8Z5/PFZjx58wayxW/Jl5l91oiTu7CyQLjdRA=; b=pfT5IkgMn65wp71e2H+x0eVE1rZ2q/JaBaKjD82WRaC8zDs/G8Nlj3CylBc1/7T6YM P/cgNphNBO9hjT36NS3Hv3+HnHFk9BkW4GSQNS7Lu34QCeQRQQZ/Z/2oBUySOq/akwa+ +pjLHAIPGtqOk2d8oXQRk6HPsmAdzmvtkLARrweX62z89sx7GXYN+uonO6Du+P/KwUci /SqCfaGGoQy8SDEoSiPPUIFAjcx8FJ69UDcBJi9vcZXlGk0DbB6YG9Y2KMB+6PojtLJY SIz12M9bHrSW2k8cZnCBGC0RZO9u81Ln1eU1rDLmdvwnsOSsmmpUguJlNo/2F1l4VjLe Mg9A== X-Gm-Message-State: AOJu0YwiKVkqQ8DSvFpv+DglZxE0hP4wRI97pkMT/n/MPySoQuOmU2KG tIQNRW/drq9IaBstw3bfvf9CZGQ0OMH9hGkHXAU6WvNjqwkXEv4Y X-Gm-Gg: ASbGncv8ciyyoyYxmCaoxAFIwuPTlBDngeIDvDQpThJdQh32vxqf/ugppAPYPRdHl2H oNpjHvMvReD/DBNyDQBtpqTJYZXROLKWwKxsSNN27bjV6SfF5Fk/I04wy9vuh/NaupJlEYbEv2z c/qiapaKP0PWEb43z4kLtuR1jcA/8071nQv5QYwv09BPh7zGLtplLOZq9sG2MzRGa6LoqweM4/G X3v65I085CDAEZ0ArlZ+4R+rn7Fyrof1E1+LaFAY35LyEz2wOiq3Qz/1kic+iYtTGIM7fc+5siR uZJDOP61T+j+lrFoDqELT6tJGVX7HK8upa954H3enafl9urFxDewHR2EtfsLyE0mD5yq0R+0Q4V Ci7oeWZZfKkXyJ84q92xipA== X-Google-Smtp-Source: AGHT+IGQdZVd9i8M31ZROOd57Codd1dlTfpryYwoYFfWhZcuSEUDackctIHDLRw+3IAuQYMVwXPYLg== X-Received: by 2002:a5d:64c7:0:b0:391:11b:c7e9 with SMTP id ffacd0b85a97d-39132d6011emr22070325f8f.28.1741812984686; Wed, 12 Mar 2025 13:56:24 -0700 (PDT) Received: from smtpclient.apple (143-45-239-77.dyn.cable.qlnet.ch. [77.239.45.143]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3912c102b62sm21681367f8f.84.2025.03.12.13.56.24 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Wed, 12 Mar 2025 13:56:24 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3826.400.131.1.6\)) Subject: Re: Moving from Linux to Linux? From: Paul Foerster In-Reply-To: <9a8d92de-228c-43b0-b66c-c3390b41044a@aklaver.com> Date: Wed, 12 Mar 2025 21:55:52 +0100 Cc: Pgsql-General List Content-Transfer-Encoding: quoted-printable Message-Id: References: <6E6059F6-E5A1-4A8D-8A5E-A41B921BBE67@gmail.com> <9a8d92de-228c-43b0-b66c-c3390b41044a@aklaver.com> To: Adrian Klaver X-Mailer: Apple Mail (2.3826.400.131.1.6) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Adrian, > On 12 Mar 2025, at 21:26, Adrian Klaver = wrote: >=20 > A good summary of the glibc issue: >=20 > https://wiki.postgresql.org/wiki/Locale_data_changes >=20 > With distro information: >=20 > = https://wiki.postgresql.org/wiki/Locale_data_changes#What_Linux_distributi= ons_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. =F0=9F=A4=A3 Also, we try to get rid of the libc locale provider and switch to = libicu, wherever possible. Cheers, Paul=