MIME-Version: 1.0
References: <20250418141817.2457ac8d@ardentperf.com> <CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE+hJw9Ug@mail.gmail.com>
In-Reply-To: <CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE+hJw9Ug@mail.gmail.com>
From: Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Date: Sun, 20 Apr 2025 00:21:05 +0530
Message-ID: <CAM+6J9686qJxTyKdPwa3anZqAH0yp0o88e+uNR_9XGdEWpAXwQ@mail.gmail.com>
Subject: Re: verify checksums online
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: Jeremy Schneider <schneider@ardentperf.com>, pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000af3d080633261e5e"
Archived-At: <https://www.postgresql.org/message-id/CAM%2B6J9686qJxTyKdPwa3anZqAH0yp0o88e%2BuNR_9XGdEWpAXwQ%40mail.gmail.com>
Precedence: bulk

--000000000000af3d080633261e5e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

iirc there used to be a Google snippet that did online checksum
verification. it worked pretty well , but I did not let it run the tests of
the extension, so it may not be 100% , I just used it for a quick check if
there were other problems visible.

if it's archived now well :)

https://github.com/google/pg_page_verification


Thanks,
Vijay

Open to work
Resume - Vijaykumar Jain <https://github.com/cabecada>

On Sat, Apr 19, 2025, 9:00=E2=80=AFPM Greg Sabino Mullane <htamfids@gmail.c=
om>
wrote:

> On Fri, Apr 18, 2025 at 5:18=E2=80=AFPM Jeremy Schneider <schneider@arden=
tperf.com>
> wrote:
>
>> but i wanted to confirm with someone - my easiest options for online
>> verifying checksums would be to trigger pg_basebackup then check
>> pg_stat_database, or to install michael's utility?
>>
>
> Your easiest option is to just use pgbackrest, which verifies checksums a=
s
> part of its process. So you are guaranteed to have every page verified at
> least as often as every full backup.
>
> Cheers,
> Greg
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>

--000000000000af3d080633261e5e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto"><p dir=3D"ltr">iirc there used to be a Google snippet tha=
t did online checksum verification. it worked pretty well , but I did not l=
et it run the tests of the extension, so it may not be 100% , I just used i=
t for a quick check if there were other problems visible.=C2=A0</p><p dir=
=3D"ltr">if it&#39;s archived now well :)=C2=A0</p><p dir=3D"ltr"><a href=
=3D"https://github.com/google/pg_page_verification">https://github.com/goog=
le/pg_page_verification</a></p><p dir=3D"ltr"><br></p><div data-smartmail=
=3D"gmail_signature"><div dir=3D"ltr">Thanks,<div>Vijay</div><div><br></div=
><div>Open to work</div><div>Resume -=C2=A0<a href=3D"https://github.com/ca=
becada" target=3D"_blank">Vijaykumar Jain</a><br></div></div></div></div><b=
r><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Sat, Apr 19, 2025, 9:00=E2=80=AFPM Greg Sabino Mullane &=
lt;<a href=3D"mailto:htamfids@gmail.com">htamfids@gmail.com</a>&gt; wrote:<=
br></div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;borde=
r-left:1px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">O=
n Fri, Apr 18, 2025 at 5:18=E2=80=AFPM Jeremy Schneider &lt;<a href=3D"mail=
to:schneider@ardentperf.com" target=3D"_blank" rel=3D"noreferrer">schneider=
@ardentperf.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex">but i wanted to confirm with someone =
- my easiest options for online<br>
verifying checksums would be to trigger pg_basebackup then check<br>
pg_stat_database, or to install michael&#39;s utility?<br></blockquote><div=
><br></div><div>Your easiest option is to just use pgbackrest, which verifi=
es checksums as part of its process. So you are guaranteed=C2=A0to have eve=
ry=C2=A0page verified at least as often as every full backup.</div><div><br=
></div><div>Cheers,</div></div><div dir=3D"ltr" class=3D"gmail_signature"><=
div dir=3D"ltr"><div>Greg</div><div><br></div><div>--</div><div>Crunchy Dat=
a - <a href=3D"https://www.crunchydata.com" target=3D"_blank" rel=3D"norefe=
rrer">https://www.crunchydata.com</a></div><div>Enterprise Postgres Softwar=
e Products &amp; Tech Support</div><div><br></div></div></div></div>
</blockquote></div>

--000000000000af3d080633261e5e--