Re: verify checksums online - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: verify checksums online
Date
Msg-id CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE+hJw9Ug@mail.gmail.com
Whole thread Raw
In response to verify checksums online  (Jeremy Schneider <schneider@ardentperf.com>)
Responses Re: verify checksums online
List pgsql-general
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: "Andy Huang"
Date:
Subject: 回复: Error while updating a table
Next
From: Vijaykumar Jain
Date:
Subject: Re: verify checksums online