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 1mbIsX-0008RU-Qf for pgsql-admin@arkaria.postgresql.org; Fri, 15 Oct 2021 08:47:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mbIsW-0005CE-Nx for pgsql-admin@arkaria.postgresql.org; Fri, 15 Oct 2021 08:47:48 +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 1mbIsW-0005C5-57 for pgsql-admin@lists.postgresql.org; Fri, 15 Oct 2021 08:47:48 +0000 Received: from truschnigg.info ([89.163.150.210]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mbIsT-0004tR-AA for pgsql-admin@lists.postgresql.org; Fri, 15 Oct 2021 08:47:47 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) by truschnigg.info (Postfix) with ESMTPSA id 7475720113; Fri, 15 Oct 2021 08:47:43 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1634287663; bh=2NlbpvuY9bKoHI+xo3Gthr818GcLu86ZIn75I8al5rc=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=e0OqwE000uTVutNzOPglygUUbdzNcQBkG3JdeyCmWTYbRw54nWVfjYI3hUrpW3CYc oUaZYcm90PoMWXHdZyGaQQ51ciYwD/gSPl96pwB7XTpivyCc17o/bQP26EIdCJ+hCi 76nfyMpZJ4BJtf8PC39V54XoINgY9vg7qZ3TIQTQ= Date: Fri, 15 Oct 2021 10:47:39 +0200 From: Johannes Truschnigg To: Julien Rouhaud Cc: =?utf-8?B?U8OpYmFzdGllbiBCb3V0dMOp?= , Pgsql-admin Subject: Re: Index Corrupted ? Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="UHCZoaSDFE00H8mC" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --UHCZoaSDFE00H8mC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Oct 15, 2021 at 04:41:41PM +0800, Julien Rouhaud wrote: > [...] > Indeed, only rebuilding all impacted indexes on the dev server will > work, or using logical replication (or a pg_dump / pg_restore). Using the same ICU release on both platforms should be an OK workaround/fix, too. That might require installation of alternative postgres packages howev= er; maybe even custom compilation. --=20 with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ --UHCZoaSDFE00H8mC Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAmFpQCgACgkQ95W3jMsY fLWU1hAAsMnz4hKhjW+B8l3LFP/zBlodFLLk+pJZ/poFdaCnKjDP4PRSty3xgE1T fYHGOhJ1H19o19XZflNzif05uwhfkvCHWWbI3nktUGTR25cv+StRWqSzBfynixNT OgpqTBWY8yCLxy9WRDQ390LB6ZLqzP6AAkac1MDTxvKdZLuwCChKuGQeaCj56FDs GTtLP1M73UV/Wn9yVz6y9BihQmLwzGAfMdI3vtzxwGV6xkuSFUI19Z7U4Ge5HrXq Zs/kkz081xy2a0j/XZhODVSuny9en1DAXiCiHVaS23tf5J6rYMi4+ypDry8QF/il uieVx1oVVTHgzL4UWcP5s33f8wG1GMzlvJH4rHJGeO5qc8heQZqqHpcqAa5XmnRe ynxNJnA06TDr1LrIkqRqAJTWBbaScawR9ggaaLPgMv/1hqYEVrAXzUYMB6h/Zhwg a5S9550jrzSoQFqIi9xtLxHoABWTStkfR6HnqFmvvN0xzn92bEY2mPCbPp9i9of8 40CuR1h63kc9NYb6oKqVJuiYdAqrJQzf+gY2NhMvwyILs1UBameWepYHWT0HHa5W 9x6QIJuR5WOeIllkbOs868FOgbcnjh+3tBqoucS8olGi0GfpyMw1H2b0lqtpw4G1 uuXRCb9orpOrGYVRBHrq8CFVtycisq/RyPeJfV6B9tBCR/MBpTA= =Y4pX -----END PGP SIGNATURE----- --UHCZoaSDFE00H8mC--