MIME-Version: 1.0
References: <20250418141817.2457ac8d@ardentperf.com>
In-Reply-To: <20250418141817.2457ac8d@ardentperf.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 18 Apr 2025 17:32:19 -0400
Message-ID: <CANzqJaDJtXkDEsq3QFY6ywL2KwObAW-twWtZ0qJCsioH-75wWQ@mail.gmail.com>
Subject: Re: verify checksums online
To: Jeremy Schneider <schneider@ardentperf.com>
Cc: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007679ee06331441b1"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaDJtXkDEsq3QFY6ywL2KwObAW-twWtZ0qJCsioH-75wWQ%40mail.gmail.com>
Precedence: bulk

--0000000000007679ee06331441b1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Apr 18, 2025 at 5:18=E2=80=AFPM Jeremy Schneider <schneider@ardentp=
erf.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?
>

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

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

--0000000000007679ee06331441b1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Apr 18, 2025 at 5:18=E2=80=AFPM J=
eremy Schneider &lt;<a href=3D"mailto:schneider@ardentperf.com">schneider@a=
rdentperf.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_con=
tainer"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex=
;border-left:1px solid rgb(204,204,204);padding-left:1ex">i should know the=
 answer to this... but asking anyway<br>
<br>
i think there had been some mailing list discussions years ago? the<br>
pg_checksum utility in core still can&#39;t do an online check right?<br></=
blockquote><div><br></div><div><a href=3D"https://www.postgresql.org/docs/1=
7/app-pgchecksums.html">https://www.postgresql.org/docs/17/app-pgchecksums.=
html</a></div><div><br></div><div><span style=3D"color:rgb(0,0,0);font-fami=
ly:&quot;Open Sans&quot;,sans-serif;font-size:14.4px">&quot;The server must=
 be shut down cleanly before running=C2=A0</span><span class=3D"gmail-appli=
cation" style=3D"box-sizing:border-box;color:rgb(0,0,0);font-family:&quot;O=
pen Sans&quot;,sans-serif;font-size:14.4px">pg_checksums</span><span style=
=3D"color:rgb(0,0,0);font-family:&quot;Open Sans&quot;,sans-serif;font-size=
:14.4px">.&quot;</span></div><div>=C2=A0</div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex">looking around, i think that michael&#39;s pg_checksum=
s_ext still seems to<br>
be available in debian repos, and it advertises online checks, which<br>
makes me think that the core pg_checksum might still not have merged<br>
any code for online checking yet<br>
<br>
but i wanted to confirm with someone - my easiest options for online<br>
verifying checksums would be to trigger pg_basebackup then check<br>
pg_stat_database, or to install michael&#39;s utility?<br></blockquote></di=
v><div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div =
dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacte=
d&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><di=
v><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--0000000000007679ee06331441b1--