On 8/20/20 14:46, Tom Lane wrote:
> There might be value in a user-invokable tool that runs in an existing
> non-crashed database and looks for orphan files, but I'm not aware that
> anyone has written one. (Race conditions against concurrent table
> creation would be a problem; but probably that can be finessed somehow,
> maybe by noting the file's creation time.)
Bertrand Drouvot just put out a tool to list potentially orphaned files
a couple months ago.
https://github.com/bdrouvot/pg_orphaned
Implemented as an extension, doesn't remove the files, but useful
nonetheless.
-Jeremy
--
http://about.me/jeremy_schneider