Re: PostgreSQL occasionally unable to rename WAL files (NTFS)

From: Guy Burgess <guy(at)burgess(dot)co(dot)nz>
To: Thorsten Schöning <tschoening(at)am-soft(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL occasionally unable to rename WAL files (NTFS)
Date: 2021-02-12 12:54:56
Message-ID: 25069fdd-a651-9476-466c-4d224b2226a8@burgess.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Noah Bergbauer 2021-02-12 14:41:37 Preventing free space from being reused
Previous Message Guy Burgess 2021-02-12 12:48:42 Re: PostgreSQL occasionally unable to rename WAL files (NTFS)