Re: PostgreSQL occasionally unable to rename WAL files (NTFS) - Mailing list pgsql-general

From Guy Burgess
Subject Re: PostgreSQL occasionally unable to rename WAL files (NTFS)
Date
Msg-id 25069fdd-a651-9476-466c-4d224b2226a8@burgess.co.nz
Whole thread Raw
In response to Re: PostgreSQL occasionally unable to rename WAL files (NTFS)  (Thorsten Schöning<tschoening@am-soft.de>)
List pgsql-general
On 12/02/2021 4:33 am, Thorsten Schöning wrote:
> If you see that somewhat frequently, use Process Monitor and Process
> Explorer to see who accesses those files how. ProcExp easily allows
> you to find all open handles per file. If it's not AV, it might be
> something like Windows Search Indexer as well, if that is enabled by
> default in Server 2019 at all.
>
Thanks Thorsten, that's a great idea - I'm using Procmon and Process 
Explorer and able to monitor activity on the WAL files, so hopefully 
that sheds some light. The Indexer service is disabled, so can rule that 
out.

Kind regards

Guy




pgsql-general by date:

Previous
From: Guy Burgess
Date:
Subject: Re: PostgreSQL occasionally unable to rename WAL files (NTFS)
Next
From: Noah Bergbauer
Date:
Subject: Preventing free space from being reused