Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder

From: Basil Peace <grv87(at)yandex(dot)ru>
To: Dave Page <dpage(at)pgadmin(dot)org>
Cc: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Subject: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
Date: 2012-06-06 19:04:39
Message-ID: 203291339009479@web11h.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

In my case invalid argument (root directory instead of specified data directory) was passed by installer to icacls. That's what I saw. It wasn't problem of icacls, it was a problem in pgsql installer.

05.06.2012, 22:38, "Dave Page" <dpage(at)pgadmin(dot)org>:
> On Sun, May 20, 2012 at 7:05 PM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:
>
>>  Excerpts from grv87's message of sáb may 19 10:28:47 -0400 2012:
>>>  The following bug has been logged on the website:
>>>
>>>  Bug reference:      6652
>>>  Logged by:          Basil Peace
>>>  Email address:      grv87(at)yandex(dot)ru
>>>  PostgreSQL version: 9.1.3
>>>  Operating system:   Windows 7 x64
>>>  Description:
>>>
>>>  I have been installing PostgreSQL 9.1.3.2, and I've noted that 'creating
>>>  database cluster' is too long. I have been waiting for a half of hour, and
>>>  it hasn't finished.
>>>  I've noted that installer calls icacls.exe with arguments:
>>>  D:\ /grant "postgres":RX
>>  This seems to be reported every once in a while.  It looks like the
>>  one-clunk installer is to blame.  Maybe it's been fixed in some more
>>  recent version -- Dave Page would probably know.
>
> Just as an FYI, we are working on this. We've been able to reproduce
> it, and it appears that icacls (a Microsoft utility) will sometimes
> look at the ACL of every file/directory recursively when it grants the
> required privileges on higher level directories. The good news is that
> in none of the test we've done has it ever modified the ACL on the
> wrong thing - it just takes a long time if there are a lot of items on
> the filesystem. We've looked at third party alternatives to icacls,
> and they seem to exhibit similar traits. We're also going to look into
> other ways around the root problem.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dave Page 2012-06-06 19:07:26 Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
Previous Message Tom Lane 2012-06-06 17:05:24 Re: BUG #6676: checkpointer does not work by SIGINT.