Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16927: Postgres can`t access WAL files - Mailing list pgsql-bugs

From Ярослав Пашинский
Subject Re: BUG #16927: Postgres can`t access WAL files
Date
Msg-id CADLmTo+e7ndbr4MMme91H2KKieS0nHA4H8ROS2Y2WfDURdr2FQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16927: Postgres can`t access WAL files  (Andres Freund <andres@anarazel.de>)
Responses Re: BUG #16927: Postgres can`t access WAL files  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
Tree view
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

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #16927: Postgres can`t access WAL files
Next
From: Ярослав Пашинский
Date:
Subject: Re: BUG #16927: Postgres can`t access WAL files