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 1vC17x-007yyG-5v for pgsql-general@arkaria.postgresql.org; Thu, 23 Oct 2025 19:37:36 +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 1vC17w-00BJ3R-0A for pgsql-general@arkaria.postgresql.org; Thu, 23 Oct 2025 19:37:35 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vC17v-00BJ3J-LS for pgsql-general@lists.postgresql.org; Thu, 23 Oct 2025 19:37:34 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vC17r-003PDO-35 for pgsql-general@lists.postgresql.org; Thu, 23 Oct 2025 19:37:33 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-592ee9a16adso2006068e87.0 for ; Thu, 23 Oct 2025 12:37:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761248250; x=1761853050; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=KwamnczTUl7kvgtUW3iVLj8rjgCsRSilfywtKmuedto=; b=lOxmwaX6kMlXyVuzM2/A/oIMbm8gbZqd2ZJ3trBqqvTgpHhqQcCS7UwS9iXwtpZzc+ ESdprhL9E5WzUiMNbkLcKUhJYIZLDLijebYMQm/UypoNZg3hwKzS2lR6nEVlVjbs9HPG XAATo+d6xEyF5Oy9iSzXAxf1/hCN5qmeFpy2IkK6HJ20MSmqO6rEQgQPfR+EoUkQQAJP cuiFMIQ7Er7QQRaQ9Vr/lXasexcUHFHAIj5MFJUSX8f0c5LgWw08W4PumOipTh+h4RWD gVdooiHHdB4FttCcfyJjCCzj4T1ffr7SOzQ9ns4FU72MCNhv+idWNC9qaQcp09OJkGJm bsAw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761248250; x=1761853050; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=KwamnczTUl7kvgtUW3iVLj8rjgCsRSilfywtKmuedto=; b=JuH5LUqLkDT+CU+ybi2tqTxDHEhLN8wZ3nG6tEh9SUGW5g6IVunfYNAXA3/6iXWJf2 dWToQJO8V9mT95MgllNGjF2BeFo+96sOVfeyl2fTJZwp6rQfdK8x5fYNG2P/XansNhuW szgw1Auz1Lr+rVxi1cR2HP7ey/VjSiU0CqzFfPKnPU8XVCBh5D+9xKILcicqvGI/v2zo wAt0e6rRVoh7S9TXqrOJHsmkGJF6nJFp8eAswH6DZ9OrQinsf33EvP9JhTGeumBQA3+D rMruNM/fh2oLTW2d1g2NhaHvD+KzZtxJZU7E6PSjK/B0/nI5D6PFsoQqrYOqo26ahrXh /lcQ== X-Gm-Message-State: AOJu0YyThIuKb1D4hbYyq9dE1zjHV8PhW0pzDcWAt5xCHYxqGoZcEKpJ o+0G7AqsOSkqspMVYvTTS0v0KjRhXPGu+DjIjS32Jdo5QPp2bZIpjqqE4MIOJZpcUttm4ugaQC5 StOGYyAblxKwTgEOv6hBRyxQPnaNMLj8= X-Gm-Gg: ASbGncskE8P2YXKfsTx6ZeKyYCfDd15+zs1p+524+xDkEKuGP7wOBIHe4REHCbDhJma TfOVLFI9n0SMx48IN/7O6R4eXyexrs9o0u0KUtGCbPUiMOOgZQlycL8dJ3bzlH5L2nUPtOTvrPb NJWmN9ibhDIOAiG4SVPofgNdJw3dRwLk0FwinxKDtHiJC+J7ODL8+vb5ICUAhgr/E5ZDp/hpxQJ 4BEWq4ZDSbFIUL+L5kbvw9yMGq95lYle2ZPFuc2TmIzwbsi5DmD+1uZmzDQKlRghIchqV73ouvQ 0ihu0KcQDHJV6CNfZT11/AHegc7b3Ei3fDQpHFZZI/ZqFejoA7T/DU5onLHMroRrRphRIIQ2 X-Google-Smtp-Source: AGHT+IHydFE5XVKCGYTUCJtbCKFxUdD/PBlqxmF9Ql2zYLr+4QtJRli+otxaa7rhSbeBRKjm5x7Qp4X52imAv70I7vs= X-Received: by 2002:a05:6512:3b0c:b0:57a:310:66a8 with SMTP id 2adb3069b0e04-591d85773ffmr8030449e87.55.1761248249487; Thu, 23 Oct 2025 12:37:29 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: David Rowley Date: Fri, 24 Oct 2025 08:37:17 +1300 X-Gm-Features: AWmQ_bmTYl7iqFAvB_o-KVcDqkVH_tqpUCPt8XHadV-aSC44tISgmDuCgMJCQGw Message-ID: Subject: Re: Index corruption issue after migration from RHEL 7 to RHEL 9 (PostgreSQL 11 streaming replication) To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= Cc: pgsql-general@lists.postgresql.org, Bala M Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 24 Oct 2025 at 07:17, Devrim G=C3=BCnd=C3=BCz w= rote: > This happens because of the glibc version differrence between RHEL X and = RHEL Y. At this point you either have to rebuild all indexes (sorry!) or re= do the upgrade via logical replication (if it works for your app's behaviou= r) There was a mention in [1] about a wiki page which includes a query to identify which indexes could be affected. While that *could* be all indexes, it does seem unlikely. David [1] https://postgr.es/m/CAOg7f80JJCMHXhNLUjnHMwBFV-f9Msv4L=3DPML0CdaZ4n47uE= eA@mail.gmail.com