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

Ярослав Пашинский <yarik97.6@gmail.com>

From: Ярослав Пашинский <yarik97.6@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: Michael Paquier <michael@paquier.xyz>, Postgres bugs <pgsql-bugs@lists.postgresql.org>
Date: 2021-03-19T08:38:51Z
Lists: pgsql-bugs
Hello, sure. Right now I found recent log for one WAL file and here is a
output of find links program:
".\FindLinks64.exe "D:\DB_update\PSQL_4\pg_wal\000000010000429E00000077"

Findlinks v1.1 - Locate file hard links
Copyright (C) 2011-2016 Mark Russinovich
Sysinternals - www.sysinternals.com

Error opening d:\db_update\psql_4\pg_wal\000000010000429e00000077:
Access is denied. "
 P.S.: I run program with admin rights.

пт, 19 мар. 2021 г. в 01:51, Andres Freund <andres@anarazel.de>:

> 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