Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
Date
Msg-id AANLkTimXN2Udiq2rGMxKiiyknkZKQKx48RfycBpMiPmg@mail.gmail.com
Whole thread Raw
In response to Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
On Mon, Jun 14, 2010 at 10:57, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander <magnus@hagander.net> wrote:
>> On Mon, Jun 14, 2010 at 05:17, John T. Dow <john@johntdow.com> wrote:
>>> Apparently the problem boils down to this question: how did some of the files get set to be system and read only?
>>
>> Yes. That would be very interesting to know. PostgreSQL never
>> (intentionally) sets these flags, so they must've come from something
>> else.
>
> Being a non-privaledged account, does the postgres user even have the
> power to do that?

Yes, IIRC any user that has write permissions on a file can set the
attributes, including readonly and system.


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
Next
From: Leonardo F
Date:
Subject: Re: Partial indexes instead of partitions