Re: verify checksums online
| От | Vijaykumar Jain |
|---|---|
| Тема | Re: verify checksums online |
| Дата | |
| Msg-id | CAM+6J9686qJxTyKdPwa3anZqAH0yp0o88e+uNR_9XGdEWpAXwQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: verify checksums online (Greg Sabino Mullane <htamfids@gmail.com>) |
| Список | pgsql-general |
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/google/pg_page_verification
On Sat, Apr 19, 2025, 9:00 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
On Fri, Apr 18, 2025 at 5:18 PM Jeremy Schneider <schneider@ardentperf.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.comEnterprise Postgres Software Products & Tech Support
В списке pgsql-general по дате отправления: