public inbox for [email protected]  

help / color / mirror / Atom feed

From: Vijaykumar Jain <[email protected]>
To: Greg Sabino Mullane <[email protected]>
Cc: Jeremy Schneider <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: verify checksums online
Date: Sun, 20 Apr 2025 00:21:05 +0530
Message-ID: <CAM+6J9686qJxTyKdPwa3anZqAH0yp0o88e+uNR_9XGdEWpAXwQ@mail.gmail.com> (raw)
In-Reply-To: <CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE+hJw9Ug@mail.gmail.com>
References: <[email protected]>
	<CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE+hJw9Ug@mail.gmail.com>

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 PM Greg Sabino Mullane <[email protected]>
wrote:

> On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider <[email protected]>
> 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 as
> 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
>
>

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: verify checksums online
  In-Reply-To: <CAM+6J9686qJxTyKdPwa3anZqAH0yp0o88e+uNR_9XGdEWpAXwQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox