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 1o1M2K-0004lU-JL for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Jun 2022 05:57:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o1M2J-00071p-Ch for pgsql-hackers@arkaria.postgresql.org; Wed, 15 Jun 2022 05:57:51 +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 1o1M2J-00071g-2o for pgsql-hackers@lists.postgresql.org; Wed, 15 Jun 2022 05:57:51 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o1M2G-0006eP-8E for pgsql-hackers@postgresql.org; Wed, 15 Jun 2022 05:57:50 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id 1E90E5C0339; Wed, 15 Jun 2022 01:57:47 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute1.internal (MEProxy); Wed, 15 Jun 2022 01:57:47 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm2; t=1655272667; x=1655359067; bh=6KqCZK+hgY Z4Wi1oXBt3b2C/My5zAF+t35aE99uauSk=; b=f05k9SaMA7JYC3z3uMcPxaghGR xmTcjDqBwKQB6TFn9ooQ+kl/X/sjw6BudlOu86lRckAU6yyySVbGpDbwPDfFlpNM ZFf+DATxVk2Vw84mWkXJdTyekkGDcdQ6phV3TAh1ynE5jJ0KF7gDGTnKsEYpWBZt PrV65d98r4J3K3WZL2Iy9WRtYpSxL6vKlhAtWQ3i92zl8FJcDGPwaPzHXiFGFeW5 iqcrmfzyObg/v4UD4Nt9pxYSikV+Qv0IkhY7lwQzY5gTsP/gmqh/h4uQlUHTZ//F UXsv6f5qJ43E5Vo2GgTmTtvRgnvw+zFpSmNX4kva2Hzh17IgbT4NN9nq0j0w== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1655272667; x=1655359067; bh=6KqCZK+hgYZ4Wi1oXBt3b2C/My5z AF+t35aE99uauSk=; b=iCgmAAw/BRA3qP8xP+YLWNbK9fE2vqzXBa2YXQDaqU+1 pibJF+mGPtby8+DjA1MfLqRumsm6iwj1pHXnnm8TrWzQH2UMfuwT4gAkEB8wFFR1 FSChjz9hWw/uDmjYpcc8rfQTEwUS2eL6J4Q/2TjnQvNaKXLrDNvHRQlAV1JTHohA mtePakwlb+FKl0+wOGQzxJ++clL51716ktdWIT2WSwde91h2QCwFDMSSlafa2t1S UkSg3Rbhwhtz83V0xy3KVBQHuqHD1UJ9aQk7QKQR4DrB1xhlJN3JoKcLZ5VV1PUo M1IGmhQVo0pW4Y6tG4YjbJ0JAb8KfaGDw6bYYq+fyQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedruddvtddgleeiucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepjeejtdelleeggeelffduhfej tdeuvdekkeethffhuedvvdeuudeugeefudevtdeinecuffhomhgrihhnpehgihhthhhusg drtghomhenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhm pehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 15 Jun 2022 01:57:45 -0400 (EDT) Date: Wed, 15 Jun 2022 14:57:43 +0900 From: Michael Paquier To: Alvaro Herrera Cc: David Christensen , Bharath Rupireddy , PostgreSQL-development , Greg Sabino Mullane Subject: Re: [PATCH] Teach pg_waldump to extract FPIs from the WAL Message-ID: References: <202205030834.4n6qbrivjtuk@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tD88EGHBzByV0pe4" Content-Disposition: inline In-Reply-To: <202205030834.4n6qbrivjtuk@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --tD88EGHBzByV0pe4 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, May 03, 2022 at 10:34:41AM +0200, Alvaro Herrera wrote: > I remember Greg Mullane posted a tool that attempts to correct page CRC > mismatches[1]. This new tool might be useful to feed healing attempts, > too. (It's of course not in any way a *solution*, because the page > might have been modified by other WAL records since the last FPI, but it > could be a start towards building a solution that scoops page contents > from WAL.) >=20 > [1] https://github.com/turnstep/pg_healer Fun. Thanks for mentioning that. -- Michael --tD88EGHBzByV0pe4 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmKpdNcACgkQnvQgOdby QH2MkA/8DDw3zgjKIXePjyQxdoMS/oMXmGrZvw772T6BVlzS8OTK8T3ipO8spK4i g4zfPLujdN2lYAbqYMaZWrZ67ZvvJtZw3JpCde7KE4NpxUZO1lAv86Wein5EGJIO W1MjkBmRy+I75Yxek65MgpNUMWdSb1z6jYtyb8PtHkYVZk28UkyNRSMe8TQ5bxPK xow9L/OFv4aPgDYdEp/aep8drwIiINZ06pmwamuEvSsNrdyZTkYwUsG9gLZDuhZi CYlZhnDZKky72fpMz6Vq651jj6Bk7WtxnuIWLutM0C83ZIkq+OE+dawYAtnWD/oE WhMoxjXBmLpKge8oekD4+RMnwp8JHFBhBvboI3CEnely0DZeZonTz74G39udOtTY C3qZvf6g/P+yVPgD1tP1XlBIPOmoJdxT+gZldH4w43Ts22B/TXctxqpC1fvBu16x +ZwD3ZggeUALO5h188yEGSj7j+LqAWyY5rTxr+NRdhipj8knY23UW5Afn75GCO1C x0pUA4krpTziWAKzI9jaYM1K07LZ7odsD9m4Xtt+NST/MCI/t633nbs4PmQWG3bJ Vi6EhSgyDDgKPqzMCz9pkA8ov3ec8C877D6pRSlUQ3PZKxwFvBY8TPL1Ewa/8XZm hy2HEc/EMhO6Pi1Rj0sSk4w/T8C6+62gfcv+S+kdipc+mTVo5cU= =WNR/ -----END PGP SIGNATURE----- --tD88EGHBzByV0pe4--