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.98.2) (envelope-from ) id 1xSyYR-000000000Ut-3lZ7 for pgsql-docs@arkaria.postgresql.org; Mon, 16 Nov 2026 15:23:36 +0000 Received: from localhost ([127.0.0.1]:36670 helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xSyYR-00000001sjQ-1Ehq for pgsql-docs@arkaria.postgresql.org; Mon, 16 Nov 2026 15:23:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]:54946) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xSyW5-00000001rNi-0qPk for pgsql-docs@lists.postgresql.org; Mon, 16 Nov 2026 15:21:09 +0000 Received: from mail-wm1-x32a.google.com ([2a00:1450:4864:20::32a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1xSyW2-000000000ot-2sXm for pgsql-docs@lists.postgresql.org; Mon, 16 Nov 2026 15:21:08 +0000 Received: by mail-wm1-x32a.google.com with SMTP id 5b1f17b1804b1-4bb64ef5a00so11767095e9.3 for ; Mon, 16 Nov 2026 07:21:06 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1794842465; x=1795447265; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:from:to :cc:subject:date:message-id:reply-to:content-type; bh=e5YiEaLXCOplMtYoUtJxz2wVR19PsdJubXEYC+SomCc=; b=I8nlLvX3TbVgPwyEuOENqzwbkd5sp47lSJExvx7B3s84ZPCTwcr8YLNy2r0zDBEABA xbUO5EJ7NsNBuhHyQx06KbumqxpZLhlNzSDNTwmguy6x7Dtu5dqLTtz/OVvMKEo06qh5 mww/QVnlscsjNkFvHaDvGQeC8WFLVpwSn3DCDfeLwjF11E6vJH7S+4EI6qJXiB8+RnsX egcsq9KobtSfAOdZdQejpS48y9of5YbDGVXWRkb0XMpAgrbBkQmpM9RvOZYt+lq28ob/ l80VTRe7F/DIWFykKI9nE8aAGJ+jaROdo7ZcFpQyi5nVsu4+/JVoEsCZtBuTmVtg44ZC WIHw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794842465; x=1795447265; h=mime-version:user-agent:content-transfer-encoding:content-type :references:in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to :content-type; bh=e5YiEaLXCOplMtYoUtJxz2wVR19PsdJubXEYC+SomCc=; b=GJ/BlJXBEYonELGWdWK+aefd+ApHHt5M598ylBBZVWQfeHSvzqM19JXMUA9dDK+yxn fsXc3soW68cprK8E4/UvCzab+gYBldJax7Zww+pmOHDeJRou9PrHrxlmmCEOjlpWJrvO ZhEuHmGNkiJvmW87CHLoyg94sfgn9AI/cYRFaOWFoiWCiNY8/Qcm4X5ImyBTu/UDIMBd FEQT5bAC6lHwyQbrnQ9V/7SlKwAo70564ZFn57c3agdykHCFxXfgVQGFWPe3Ordb7/rW ckLzHH4x7YkxjvLlL+sZXhRpeWOh/iCjep5YvCFQKbko7N/foIB2Z/JbotNtNLAy0MvI xwfg== X-Gm-Message-State: APuU4Z9e7P89rnuB0NMqMWh1vfiNypH1OzRUPuVHU/LJe5RbTqZIV6FC UerGIYFHC7V8otaQ7IbT2U6SY413+LeNMnKqa5IAqTifHltxLsUQSacTG+gdqUU4ULg= X-Gm-Gg: AYBFou0X9X2Z/z7tDdfh64hlGSl2jNDdAK1kSa+CY9BcfR5rfz/r9Vh0pphp7+U0rez us+G9ETXQf5RV4rqlkuOKWQ+cx/Ip/TG5HHDAWPCGjkgcNY4NFK3Ewuui2rh2thkIZH2sYku2kU Q0CxwynXDlyzXLAja7ZqlOE23jHU/4n1/06VurAS5O0hSD49U5hzDObCgl8CEfF78zP7NJU1IpP KTbe6i/Y85kcZ0ziuYJtZWnZTZ1UzwHXoriA+3lIUg5qUv86LIOTfCf8w+CM4N120C3LVXXilMp dnIqEgFbixj1QSaj4LIO68/Bng7e2rz7CmjfMkDh+Vfwtuh4ujEJTFYnu9PEpnQ1m+Zjpz7jmpn 7qvL86v2uVsOzBXnOZkjXpdcJgidAW0EWvPqYDDS/VkOD8xYu/kUsWZ2hBJAgIHZiy8kuohg3KQ qUshNXPSadeUh1vyzzp9tpEj5LMd1KY3LGM7aTzpYcpqJl3zhWrTJUMhYoQqPaVr0Dy2XaLRpa5 pue1uqBG42x30CWMepcoAZFgrWpHccReDgptGsi12RU0MOQaltzCMpihkOEd7bZl1NknS6sbBvN NV4Ic5GePoebszj3y3vg19J8lgQ88Lkt1LluHu7TxEP4xYuA9Q== X-Received: by 2002:a05:600c:8b34:b0:4a0:1c0e:b057 with SMTP id 5b1f17b1804b1-4bb55a25bd7mr216264975e9.4.1794842464798; Mon, 16 Nov 2026 07:21:04 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([213.208.157.37]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4bb55a0ffcdsm269772045e9.0.2026.11.16.07.21.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 16 Nov 2026 07:21:03 -0800 (PST) Message-ID: <33876ecbca9932f1758b048ae9af9107bbeef55e.camel@cybertec.at> Subject: Re: OS system version upgrade (glibc / libicu version change) From: Laurenz Albe To: Alexey Shishkin Cc: pgsql-docs@lists.postgresql.org Date: Mon, 16 Nov 2026 16:21:01 +0100 In-Reply-To: References: <177002326159.803.1983703962002247846@wrigleys.postgresql.org> <225d52b51ed9a911ced2f8e6c00e089a1ce50f19.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.60.2 (3.60.2-3.fc44) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2026-11-16 at 13:00 +0100, Alexey Shishkin wrote: > We can grab the text for problem description from=C2=A0https://wiki.postg= resql.org/wiki/Locale_data_changes >=20 > Regarding finding the affected indexes, ready SQL queries for various PG = versions are > listed in the EDB KBA=C2=A0written by Peter Eisentraut. > Or/and we can use amcheck as you suggested. >=20 > Also we should=C2=A0mention that not only indexes=C2=A0can be affected by= locale changes, but other objects > like range-partitioned tables. >=20 > One more thing to stress is that locale changes can happen=C2=A0during th= e lifecycle of the same major > OS version, so any OS updates need=C2=A0to be verified=C2=A0for glibc cha= nges. >=20 > Pls. let me know how you would like to proceed. Sure. You write a documentation patch, submit it to this list, and I am ha= ppy to review it. I suggest that the patch should not be too big. Code samples and instructi= ons for repair would be too much in my opinion. I'd say that the objective is to alert th= e reader to the problem and tell him or her to rebuild affected indexes with REINDEX, a= nd to use amcheck to check if indexes are ok. Yours, Laurenz Albe