Re: Transaction Logs Recycling Problem

On Mon, 17 Feb 2003, Tom Lane wrote:

> "Colin Mangiagalli" <colin(at)camara(dot)co(dot)za> writes:
> > Sometimes I get an FATAL 2 ERROR because postgresql appears to
> > be trying to write to a log file, that returns a permission denied
> > error.
> > I am starting to think that the problem my not be with the database,
> > but with cygwin and windows 2000
>
> We've seen reports before of permission-denied errors on log file writes
> --- which makes no sense at all, because the ownerships and permissions
> of those files don't change. At least Postgres doesn't change them.
> Perhaps the problem is that some other process is running around
> altering permissions? Next time you see it, look to see what exactly
> *is* the ownership and permission of the file being complained of.
>
> I know this has been reported before on Cygwin. I can't recall that it's
> been reported on any other platform. It may be a Windows-specific
> problem.
>

Doesn't Windows have this odd feature that only one process can have a file
open at any one time. Would a second process using cygwin see this as a
permission denied?

Just throwing an idea in to the ring on the off chance.

--
Nigel J. Andrews