Re: verify checksums online - Mailing list pgsql-general

From Ron Johnson
Subject Re: verify checksums online
Date
Msg-id CANzqJaDJtXkDEsq3QFY6ywL2KwObAW-twWtZ0qJCsioH-75wWQ@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:
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?


"The server must be shut down cleanly before running pg_checksums."
 
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?

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-general by date:

Previous
From: Jeremy Schneider
Date:
Subject: verify checksums online
Next
From: Jeremy Schneider
Date:
Subject: Re: verify checksums online