MIME-Version: 1.0
References: <20250418141817.2457ac8d@ardentperf.com>
In-Reply-To: <20250418141817.2457ac8d@ardentperf.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Sat, 19 Apr 2025 11:29:42 -0400
Message-ID: <CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE+hJw9Ug@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="000000000000ec73340633234f9d"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLViSdwH2mhAQnpRueB7toZxkf_WUcpS9ZhBiE%2BhJw9Ug%40mail.gmail.com>
Precedence: bulk

--000000000000ec73340633234f9d
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:

> 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, which verifies checksums as
part of its process. So you are guaranteed to have every page verified at
least as often as every full backup.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000ec73340633234f9d
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">but i wanted to c=
onfirm 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><div=
><br></div><div>Your easiest option is to just use pgbackrest, which verifi=
es checksums as part of its process. So you are guaranteed=C2=A0to have eve=
ry=C2=A0page verified at least as often as every full backup.</div><div><br=
></div><div>Cheers,</div></div><div dir=3D"ltr" class=3D"gmail_signature"><=
div dir=3D"ltr"><div>Greg</div><div><br></div><div>--</div><div>Crunchy Dat=
a - <a href=3D"https://www.crunchydata.com" target=3D"_blank">https://www.c=
runchydata.com</a></div><div>Enterprise Postgres Software Products &amp; Te=
ch Support</div><div><br></div></div></div></div>

--000000000000ec73340633234f9d--