Re: Error: Could not open relation... - Mailing list pgsql-general

From Howard Cole
Subject Re: Error: Could not open relation...
Date
Msg-id 483744FF.6090604@selestial.com
Whole thread Raw
In response to Re: Error: Could not open relation...  (Adrian Klaver <aklaver@comcast.net>)
Responses Re: Error: Could not open relation...  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Adrian Klaver wrote:
On Friday 23 May 2008 6:02 am, Howard Cole wrote: 
Howard Cole wrote:   
Looks like someone or something changed the permissions on the
postgresql folders or files.

Sincerely,

Joshua D. Drake       
I've had a look at this file, and postgres has "Full Control".
Howard     
Further, the system works fine normally. The permissions error appears
to be an isolated error. Is it possible that this error means something
else?

Are there likely to be serious integrety implications if Postgres failed
to access/write to this table for whatever reason, or would the
transaction be rolled back.   
Previous reports of this type of intermittent behavior on Windows have been 
traced back to AV software. 
 
The server does run NOD32 AV but it is switched off for the data directory. Is there a possibility that file system errors can be reported if there is a heavy load on the file system? The server also runs as a file server.

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: XML Support related questions
Next
From: Alvaro Herrera
Date:
Subject: Re: Short-circuiting FK check for a newly-added field