Re: verify checksums online - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: verify checksums online
Date
Msg-id CAM+6J9686qJxTyKdPwa3anZqAH0yp0o88e+uNR_9XGdEWpAXwQ@mail.gmail.com
Whole thread Raw
In response to Re: verify checksums online  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general

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

On Sat, Apr 19, 2025, 9:00 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider <schneider@ardentperf.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 as part of its process. So you are guaranteed to have every page verified at least as often as every full backup.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-general by date:

Previous
From: Greg Sabino Mullane
Date:
Subject: Re: verify checksums online
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Error while updating a table