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 CADLmToKd=eFW9E+p7i0sxHOZZKshShvJSedD3ek=+PqhiXt4jg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16927: Postgres can`t access WAL files  (Michael Paquier <michael@paquier.xyz>)
List pgsql-bugs
Okay, I`ll try to build from source today following the instructions that you sent to me. And another question is how to apply patch or you will send me links with build + patch?
By the way, unfortunately, yesterday another 3 postgres instances started "complaining" about access to wal files in logs, so that why I`m interesting in fixing this ASAP :)

чт, 18 мар. 2021 г. в 00:27, Michael Paquier <michael@paquier.xyz>:
On Wed, Mar 17, 2021 at 10:34:05AM +0200, Ярослав Пашинский wrote:
> I am able to run compiled binaries + patch on my servers, that not a
> problem. Or I could also compile if you could tell me briefly how to do
> that because it`s real useful skill :)

There is some documentation to do that with Visual Studio:
https://www.postgresql.org/docs/devel/install-windows.html
In my case, I just use a command prompt to launch those commands and
do the work.  I can send you links to download custom builds, of
course.  My guess is that these should be able to work on your host,
as Windows is good in terms of backward-compatibility.

> I attached 2 files: files_list.txt - that content of pg_wal directory;
> second file file_option.png - properties of one wal file that postgres
> can`t access. Strange thing is even with domain admin or local admin I
> can`t see rights properties for this file.

Thanks.  The .deleted files come from RemoveXlogFile() where a file
gets removed.  This means that a rename before doing an unlink()
fails.  What we are looking for here is what is holding those files
back.
--
Michael

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16931: source code problem about commit_ts
Next
From: Michael Paquier
Date:
Subject: Re: BUG #16927: Postgres can`t access WAL files