Re: Strange issue with NFS mounted PGDATA on ugreen NAS - Mailing list pgsql-hackers

Larry Rosenman <ler@lerctr.org> writes:
> On 12/31/2024 12:22 pm, Larry Rosenman wrote:
>> When I try to drop a database, PostgreSQL leaves files in the directory 
>> and does not even try to delete them.
>> PostgreSQL 16.6, FreeBSD 14.2, PGDATA mounted NFS from UGreen NAS.

FWIW, I couldn't reproduce such a problem with PG running on macOS
Sequoia and using an NFS mount from a RHEL8 machine.  (I tried with
current master code, but I don't believe that we fixed any related
bugs recently.)

Can you try some other combinations of host OS and NFS source,
and see if you can identify what's needed to cause the failure?

What it looks like is that readdir() is skipping over some files,
which would almost certainly be an NFS server bug.  But that
theory could be wrong.

            regards, tom lane