Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: "John T(dot) Dow" <john(at)johntdow(dot)com>, "adrian(dot)klaver(at)gmail(dot)com" <adrian(dot)klaver(at)gmail(dot)com>, "Joseph M(dot) Newcomer" <newcomer(at)flounder(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied
Date: 2010-06-14 08:59:18
Message-ID: AANLkTimXN2Udiq2rGMxKiiyknkZKQKx48RfycBpMiPmg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 14, 2010 at 10:57, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Mon, Jun 14, 2010 at 2:35 AM, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
>> On Mon, Jun 14, 2010 at 05:17, John T. Dow <john(at)johntdow(dot)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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Leonardo F 2010-06-14 09:24:55 Re: Partial indexes instead of partitions
Previous Message Scott Marlowe 2010-06-14 08:57:46 Re: Re: Error on Windows server could not open relation base/xxx/xxx Permission denied