Alvaro Herrera <alvherre@alvh.no-ip.org> 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