model-writtenrun 9859 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Michael Paquier opened the thread with EXEC_BACKEND checksum failures, temporary-file handling problems, and missed directory traversal, proposing shared relation-name parsing for pg_verify_checksums and base backups in #1.
- Stephen Frost opposed silently ignoring unfamiliar files because that could conceal missed checks and accidental files, while Michael Paquier defended extensibility and separating immediate fixes from future APIs in #2 and #6.
- An unrelated branch began when Renato dos Santos proposed making psql handle SIGQUIT like SIGINT in #3; Tom Lane objected that this would remove useful debugging and emergency-exit behavior in #4, and no revised patch or landing followed.
- Kyotaro Horiguchi proposed a compromise in #9: classify known, excluded, and unknown files, report skipped files, and share the classifier between checksum verification and base backups.
- Stephen Frost considered that classifier too complex for a PostgreSQL 11 fix in #10, and David Steele recommended restoring exclusion lists and adding EXEC_BACKEND files while postponing a common facility in #11.
- The disagreement persisted after PostgreSQL 11.1 shipped: Michael Paquier still preferred filename whitelisting in #15, while Andres Freund defended that approach and Stephen Frost explained why backups should finish collecting data despite checksum failures in #17 and #18.
- Michael Banck's report that non-default tablespaces were skipped brought renewed urgency, relayed by Michael Paquier in #22; Stephen Frost requested a whitelist revert in #23, and Paquier accepted that direction while retaining necessary temporary-file, EXEC_BACKEND, and traversal fixes in #24.
- Michael Paquier submitted two patches in #26: restore the blacklist while preserving useful regression tests, then fix exclusions and traversal with temporary-file tests and Michael Banck's tablespace-corruption test.
- Stephen Frost requested comments keeping the frontend and backend exclusion lists synchronized in #27, Michael Paquier added them in #28, and David Steele approved the submission in #29.
- The first attachment of #26 landed unchanged as a1c91dd110, restoring the blacklist and removing tests that depended on ignoring unfamiliar filenames.
- The second attachment of #26 landed as 5c99513975, adding the requested comments and refactoring the corruption tests; Michael Paquier confirmed both commits in #31 and explained that he retained their separation for clarity.
- Michael Banck reopened the discussion months later because a filename such as global/123. caused pg_checksums to fail in #32; Michael Paquier considered the whitelist proposal abandoned but acknowledged that the segment-number diagnostic could improve in #33.
- After Stephen Frost and Andres Freund again disagreed over unfamiliar files in #34 and #35, Magnus Hagander proposed preserving complaints by default while offering a switch to suppress them in #37; Frost and Paquier accepted that direction in #38 and #39, but no implementation was posted before the thread ended.