datachecksums: handle invalid and dropped databases during enable

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: datachecksums: handle invalid and dropped databases during enable
Date: 2026-07-28 10:01:43
Message-ID: CAN4CZFOGdqxtZ5-6gb4apqmvoH=Z+TNH8RKJ3mVtoR1HirKQWg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

While testing the online enabling of datachecksums, I discovered some
corner cases that can cause the background process to fail:

* Invalid databases were only discovered when we tried to create
checksums for them, when we could instead discover them before
starting and fail early
* Databases dropped while the checksum process was running also
resulted in errors when it reached them and tried to build checksums
for them. In this case we could continue safely: the database was
dropped, there's no need to create checksums for it.

I attached a patch that adds testcases for these and fixes the issues.

Attachment Content-Type Size
0001-datachecksums-handle-invalid-and-dropped-databases-d.patch application/octet-stream 10.3 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andy Pogrebnoi 2026-07-28 10:36:33 Re: Return pg_control from pg_backup_stop().
Previous Message Florin Irion 2026-07-28 09:53:14 Re: pg_plan_advice: add NO_ scan and join method tags