public inbox for [email protected]  

help / color / mirror / Atom feed

verify checksums online
3+ messages / 2 participants
[nested] [flat]

* verify checksums online
@ 2025-04-18 21:18  Jeremy Schneider <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Jeremy Schneider @ 2025-04-18 21:18 UTC (permalink / raw)
  To: 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






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: verify checksums online
@ 2025-04-18 21:32  Ron Johnson <[email protected]>
  parent: Jeremy Schneider <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Ron Johnson @ 2025-04-18 21:32 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:

> 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?
>

https://www.postgresql.org/docs/17/app-pgchecksums.html

"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!


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: verify checksums online
@ 2025-04-18 22:18  Jeremy Schneider <[email protected]>
  parent: Ron Johnson <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: Jeremy Schneider @ 2025-04-18 22:18 UTC (permalink / raw)
  To: Ron Johnson <[email protected]>; +Cc: pgsql-general

On Fri, 18 Apr 2025 17:32:19 -0400
Ron Johnson <[email protected]> wrote:

> On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider
> <[email protected]> wrote:
> 
> > 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?
> >
> 
> https://www.postgresql.org/docs/17/app-pgchecksums.html
> 
> "The server must be shut down cleanly before running pg_checksums."

Yes I read the docs. This utility has evolved over time including a
complete rename, and I was just doublechecking here that we didn't miss
a doc update in case this sentence applied to enable/disable but not to
verify. As I said I'm assuming it's all accurate but just doing the
paranoid double-check

-Jeremy






^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2025-04-18 22:18 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-04-18 21:18 verify checksums online Jeremy Schneider <[email protected]>
2025-04-18 21:32 ` Ron Johnson <[email protected]>
2025-04-18 22:18   ` Jeremy Schneider <[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