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
-
Fix concurrency issues with WAL segment recycling on Windows
- 78c24e97dd18 13.3 landed
- 909b449e00fc 14.0 landed