Re: SV: Log files polluted with permission denied error messages after every 10 seconds

Hi Andrus,

On Thu, Mar 11, 2021 at 2:21 AM Andrus <kobruleht2@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 <shammat@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.