Re: verify checksums online

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 <htamfids(at)gmail(dot)com>
wrote:

> On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider <schneider(at)ardentperf(dot)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
>
> --
> Crunchy Data - https://www.crunchydata.com
> Enterprise Postgres Software Products & Tech Support
>
>