public inbox for [email protected]
help / color / mirror / Atom feedRe: verify checksums online
2+ messages / 2 participants
[nested] [flat]
* Re: verify checksums online
@ 2025-04-19 15:29 Greg Sabino Mullane <[email protected]>
2025-04-19 18:51 ` Re: verify checksums online Vijaykumar Jain <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Greg Sabino Mullane @ 2025-04-19 15:29 UTC (permalink / raw)
To: Jeremy Schneider <[email protected]>; +Cc: pgsql-general
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: verify checksums online
2025-04-19 15:29 Re: verify checksums online Greg Sabino Mullane <[email protected]>
@ 2025-04-19 18:51 ` Vijaykumar Jain <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Vijaykumar Jain @ 2025-04-19 18:51 UTC (permalink / raw)
To: Greg Sabino Mullane <[email protected]>; +Cc: Jeremy Schneider <[email protected]>; 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 <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
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2025-04-19 18:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-19 15:29 Re: verify checksums online Greg Sabino Mullane <[email protected]>
2025-04-19 18:51 ` Vijaykumar Jain <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox