Re: verify checksums online

2025-04-23 Thread Michael Banck
Hi, On Fri, Apr 18, 2025 at 03:18:26PM -0700, Jeremy Schneider wrote: > On Fri, 18 Apr 2025 17:32:19 -0400 > Ron Johnson wrote: > > > On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider > > wrote: > > > > > i think there had been some mailing list discussions years ago? the > > > pg_checksum util

Re: verify checksums online

2025-04-19 Thread Vijaykumar Jain
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

Re: verify checksums online

2025-04-19 Thread Greg Sabino Mullane
On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider 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,

Re: verify checksums online

2025-04-18 Thread Jeremy Schneider
On Fri, 18 Apr 2025 17:32:19 -0400 Ron Johnson wrote: > On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider > 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/d

Re: verify checksums online

2025-04-18 Thread Ron Johnson
On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider 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-pgc

verify checksums online

2025-04-18 Thread Jeremy Schneider
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 a