Re: "Permission denied" failures occurring on Windows

Zubkovsky, Sergey wrote:
> Hello.
>
>
>
> In spite of the fact that as it was outlined in the "change log" to
> PostgreSQL 8.2.2, the bug of the periodical "permission denied" error
> occurrence was fixed:
>
>
>
>   “Fix bogus "permission denied" failures occurring on Windows due to
> attempts to fsync already-deleted files (Magnus, Tom)”
>
>
>
> I still can observe such erroneous behavior in the latest release of
> PostgreSQL:
>
>
>
>   select version();
>
>   "PostgreSQL 8.2.3 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
>
>
>
> Typical error message is the following:
>
>   2007-03-16 22:21:08 ERROR:  could not open relation 16405/16406/2609:
> Permission denied
>

The obvious question before we even think about anything else - any
antivirus, antispyware or any other third party software on the machine
that may be using a filter driver?

//Magnus