Re: Error: Could not open relation...

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Howard Cole <howardnews(at)selestial(dot)com>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Error: Could not open relation...
Date: 2008-05-24 05:01:13
Message-ID: 20080524010113.07bea2e5@mha-laptop.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2008-05-24 11:32:06 Re: XML Support related questions
Previous Message Teodor Sigaev 2008-05-24 04:07:48 Re: [GENERAL] Fragments in tsearch2 headline