Hi
Where you getting the Postgres binaries from?
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads
If we provide a patch, could you test it?
Yes
This would require that you do your own build, unfortunately, but having an environment where this is easily reproducible is a key thing.
I used C last time many years ago. I'm working in C# with Visual Studio 2019.
I have two Windows 2019 servers. In Intel Xeon Cold 6226R server it occurs after every 10 seconds. Last logs:
2021-03-16 13:48:12 EET checkpointer LOG: could not rename file "pg_wal/000000010000001100000097": Permission denied 2021-03-16 13:48:22 EET checkpointer LOG: could not rename file "pg_wal/000000010000001100000098": Permission denied 2021-03-16 13:48:32 EET checkpointer LOG: could not rename file "pg_wal/000000010000001100000099": Permission denied 2021-03-16 13:48:42 EET checkpointer LOG: could not rename file "pg_wal/00000001000000110000009A": Permission denied 2021-03-16 13:48:52 EET checkpointer LOG: could not rename file "pg_wal/00000001000000110000009D": Permission denied 2021-03-16 13:49:02 EET checkpointer LOG: could not rename file "pg_wal/0000000100000011000000A0": Permission denied
In AMD Ryzen 3970X Threadripper 32 core processor server in also occurs many times per day day but less frequently. Last logs:
2021-03-16 13:45:20 EET checkpointerLOG: could not rename file "pg_wal/000000010000004E000000FB": Permission denied 2021-03-16 13:50:02 EET checkpointerLOG: could not rename file "pg_wal/000000010000004E000000FB": Permission denied 2021-03-16 13:50:13 EET checkpointerLOG: could not rename file "pg_wal/000000010000004F00000082": Permission denied
So It should be probably reproducible in any Windows 2019 server. Andrus.
