verify checksums online

From: Jeremy Schneider <schneider(at)ardentperf(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: verify checksums online
Date: 2025-04-18 21:18:17
Message-ID: 20250418141817.2457ac8d@ardentperf.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

i should know the answer to this... but asking anyway

i think there had been some mailing list discussions years ago? the
pg_checksum utility in core still can't do an online check right?

looking around, i think that michael's pg_checksums_ext still seems to
be available in debian repos, and it advertises online checks, which
makes me think that the core pg_checksum might still not have merged
any code for online checking yet

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?

-Jeremy

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2025-04-18 21:32:19 Re: verify checksums online
Previous Message Mansky, Edmund J. (GSFC-671.0)[ADNET Affiliate] 2025-04-18 20:27:27 Re: [EXTERNAL] Re: Why is an error not thrown when the time exceeds the lock timeout for an ExclusiveLock on a transaction ?