Re: [GENERAL] Checkpoint request failed on version 8.2.1.

Magnus Hagander <magnus@hagander.net> writes:
> Tom Lane wrote:
>> Actually, it could still be the same problem, with the AV software only
>> involved to the extent that it's trying to scan files for viruses.

> Partially the same, but I've seen AV software keeping it open for
> hours... Basically until reboot.

Well, the bug report that just went by proves there's another problem:

: select version();
:
: "PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
: 3.4.2 (mingw-special)"
:
: pg_log:
:
: 2007-01-12 17:23:16 PANIC:  could not open control file
: "global/pg_control": Permission denied

pg_control is certainly not ever deleted or renamed, and in fact I
believe there's an LWLock enforcing that only one PG process at a time
is even touching it.  So we need another theory to explain this one :-(
... anyone have a better one than "Windows is a piece of junk"?

            regards, tom lane