Re: BUG #16927: Postgres can`t access WAL files

Andres Freund <andres@anarazel.de>

From: Andres Freund <andres@anarazel.de>
To: Ярослав Пашинский <yarik97.6@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>, Postgres bugs <pgsql-bugs@lists.postgresql.org>
Date: 2021-03-18T23:51:22Z
Lists: pgsql-bugs
Hi,

On 2021-03-18 14:16:21 +0200, Ярослав Пашинский wrote:
> The strange thing is why one server works fine on unpatched binaries while
> the second one requires a patched version to get rid of pg_wal access
> error.
> UPD: just right now on developer server I got an error: "2021-03-18
> 14:11:39.444 EET [892] LOG:  could not rename file
> "pg_wal/00000001000009130000006F": Permission denied"
> Will switch to patched binaries and tell you later.

Could you use
https://docs.microsoft.com/en-us/sysinternals/downloads/findlinks on one
of the files that can't be renamed? Or even better, the all the WAL
files?

Greetings,

Andres Freund



Commits

  1. Fix concurrency issues with WAL segment recycling on Windows