Re: Transaction Logs Recycling Problem - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: Transaction Logs Recycling Problem
Date
Msg-id Pine.LNX.4.21.0302171542010.2991-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: Transaction Logs Recycling Problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, 17 Feb 2003, Tom Lane wrote:

> "Colin Mangiagalli" <colin@camara.co.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


pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Index not used with IS NULL
Next
From: Kenéz Attila
Date:
Subject: shmget problem with Win NT services