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

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(at)paquier(dot)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
>