Received-SPF: pass (thebighonker.lerctr.org: domain of lerctr.org designates 2607:9c00:1009::53:1 as permitted sender) client-ip=2607:9c00:1009::53:1; envelope-from=ler@lerctr.org; helo=webmail.lerctr.org;
MIME-Version: 1.0
Date: Tue, 31 Dec 2024 14:46:56 -0600
From: Larry Rosenman <ler@lerctr.org>
To: Pgsql hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Strange issue with NFS mounted PGDATA on ugreen NAS
In-Reply-To: <04f95c3c13d4a9db87b3ac082a9f4877@lerctr.org>
References: <04f95c3c13d4a9db87b3ac082a9f4877@lerctr.org>
Message-ID: <8697784680e2f394debe28e282f5e8d4@lerctr.org>
Content-Type: text/plain; charset=US-ASCII;
 format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: <https://www.postgresql.org/message-id/8697784680e2f394debe28e282f5e8d4%40lerctr.org>
Precedence: bulk

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.
> 
> Truss of the create/delete attached.
> 
> It does NOT seem to happen PG < 16.
> 
> Ideas?
as a followup, 17.2 exhibits the same behavior, but 15.10 and below work 
just fine on the same VM and share.


-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 214-642-9640                 E-Mail: ler@lerctr.org
US Mail: 13425 Ranch Road 620 N, Apt 718, Austin, TX 78717-1010