Hi Andrus, On Thu, Mar 11, 2021 at 2:21 AM Andrus <kobrule...@hot.ee> wrote: > Windows Resource manger shows that wal files are used by large number of > postgres processes: > > postgres.exe 22656 File C:\Program > Files\PostgreSQL\13\data\pg_wal\000000010000000A00000075 > postgres.exe 30788 File C:\Program > Files\PostgreSQL\13\data\pg_wal\000000010000000A00000075 > postgres.exe 14144 File C:\Program > Files\PostgreSQL\13\data\pg_wal\000000010000000A00000074 ...
This is normal -- postgres.exe holds open various files it's interested in, and it's supposed to be OK for them to be renamed or unlinked at any time by another process because they are opened with special FILE_SHARE_XXX flags that allow that. That list doesn't show the open flags, but it looks like nothing *else* has the files open. Usually when these types of errors are reported on the mailing list, it turns out to be due to some other program opening the file without those flags. It's also possible that this is a real permissions problem, and not a sharing violation. I'd definitely look into this feedback: On Tue, Mar 9, 2021 at 11:19 PM Thomas Kellerer <sham...@gmx.net> wrote: > The data directory should not be stored in "C:\Program File"s on Windows. > > I wouldn't be surprised if "Program Files" has some additional security > settings that come into play here. > > %ProgramData% is a better location for the data directory.
