Date: Thu, 18 Mar 2021 07:27:31 +0900
From: Michael Paquier <michael@paquier.xyz>
To: =?utf-8?B?0K/RgNC+0YHQu9Cw0LIg0J/QsNGI0LjQvdGB0LrQuNC5?=
 <yarik97.6@gmail.com>
Cc: Postgres bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #16927: Postgres can`t access WAL files
Message-ID: <YFKB0ccg5zN+nS0Z@paquier.xyz>
References: <16927-67c570d968c99567@postgresql.org>
 <YFAH1LbeUeXTFcEM@paquier.xyz>
 <CADLmToLD6a=eXvh+b6u+Ju5Bm2ZvtCHBnCqY_d8U9we+315HZg@mail.gmail.com>
 <YFBu8b4dH32kQwDG@paquier.xyz>
 <CADLmTo+Kb0EzCFH1yYdjKneQYG=OsEX4=naAjaHOAeeNmY=HLA@mail.gmail.com>
 <YFCF+JbyfObn5zPu@paquier.xyz>
 <CADLmTo+gkFJ9or_Mfp6KKEj9MAip_BgHG6A9mzxR1DMpuRp3fg@mail.gmail.com>
 <YFExaMohbb8tqM3k@paquier.xyz>
 <YFFFkWzunPO9M6kV@paquier.xyz>
 <CADLmToLRCck9P7k=iOzLZRU7FiUmFTTTTggxF3gc0a1RasYrhQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="o921DJsw9vBLYrlL"
Content-Disposition: inline
In-Reply-To: 
 <CADLmToLRCck9P7k=iOzLZRU7FiUmFTTTTggxF3gc0a1RasYrhQ@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YFKB0ccg5zN%2BnS0Z%40paquier.xyz>
Precedence: bulk


--o921DJsw9vBLYrlL
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Wed, Mar 17, 2021 at 10:34:05AM +0200, =D0=AF=D1=80=D0=BE=D1=81=D0=BB=D0=
=B0=D0=B2 =D0=9F=D0=B0=D1=88=D0=B8=D0=BD=D1=81=D0=BA=D0=B8=D0=B9 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

--o921DJsw9vBLYrlL
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmBSglMACgkQnvQgOdby
QH0Pfw//ZbroJ9GOUzmpqopQ1E5TvaygQ9+SBJqGkeYkb2UPx9UD18Na1VpPPrLQ
exC2WW+EGcTw7oA9GN8yueNzyZc6ixxwLUXyINP5lA0v28m6Im1d7c+m+/7io0ti
CfRvrmDAgnQH1ODsm0snpaZY1Err4ukXlr5EpH490p/I7i4tEBk0M+JdKNT3fHOA
VHvnnwZYfbHbTkRA5FD8pLp1XpXKghU7j1biFnei94+xD8jq0ilKCvhr1pDClvb5
NtAL1Ab9G4fHsrVX/GjasUSTOzKol1Xb3l/AEIZTGCZqrPMURS5/or5T/dU7qTL3
op0iUJjf25n6abDNcpzCVkVCxtWUBJ9afHs4JxsX7K+sZirEmf0EaH3/sKJ4Tc1g
zLfBFzlz8QnzzxnePVC/RZ0L2hj2IZub5mXvXC2t7IAiZNtRYt0J0Sp6qyqBHssB
0aYoka5zRe1PBVJfdhA0aZOzZHe1137vl56EbJIpPsn7mpSZ11QZVRgp4pS5ssTw
XLt5pW3EbMa84B1P+O/VV60HtWF3H9pzrYODUIe7ZT84wZARpx8bK43MyQNXvYtc
GIpIYz3+YJOb0bLducbOSycGStW+gBcLmIsiVZGvqv/RvBy/HKTyMBF7C3A0eHsz
YNS5fqVUnEjpcLANqLi0Z1zBFrrb1yyqYQb3SL1jSKlXeZbOHMg=
=kpLG
-----END PGP SIGNATURE-----

--o921DJsw9vBLYrlL--