Alvaro Herrera <alvherre@xxxxxxxxxxxxxx> writes: > Tom Lane wrote: >> However, assuming you've gotten that detail right, then any file >> you can't match up with a relfilenode value must be an orphan you >> can just "rm". > Maybe look in pg_buffercache for entries referencing those files before > deleting. It would be surprising to see any if no catalog points to > those files, but who knows ... If you break checkpointing, you're not > going to be pleased. Even if there are any such entries, surely they ought to be clean by now and thus not a hazard. Not that a manual "CHECKPOINT" might not be a good idea. regards, tom lane
