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

From Magnus Hagander
Subject Re: Error: Could not open relation...
Date
Msg-id 20080524010113.07bea2e5@mha-laptop.hagander.net
Whole thread Raw
In response to Re: Error: Could not open relation...  (Howard Cole <howardnews@selestial.com>)
List pgsql-general
Howard Cole wrote:
> 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.

NOD32 is known to cause problems (at least with some versions) even
when it's switched off. Try completely uninstalling it to get rid of
the filter driver and see if that removes your problems.

//Magnus

pgsql-general by date:

Previous
From: Teodor Sigaev
Date:
Subject: Re: Fragments in tsearch2 headline
Next
From: Laurent ROCHE
Date:
Subject: sequences and dependences