Skip site navigation (1) Skip section navigation (2)

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

From: Trey Chadick <tchad(at)labkey(dot)com>
To: Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
Date: 2012-07-16 23:01:00
Message-ID: CAJEe-zSNA1MA1_9Z_63xgEUqSSEocSKgeJEHQjiSwwtMJZj=8w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Excerpts from Dave Page's message of mar jun 05 14:38:54 -0400 2012:
>
> On Sun, May 20, 2012 at 7:05 PM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:

> >> 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.


The 9.1.4 installer is still exhibiting this behavior; not as bad as
the original bug, but still pushing 30 minutes. Has there been any
luck with finding a work-around?

Thank you,
Trey

--
Trey Chadick  (LabKey Software)
tchad(at)labkey(dot)com

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-07-17 02:15:35
Subject: Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)
Previous:From: Mike WilsonDate: 2012-07-16 19:56:25
Subject: Re: BUG #6733: All Tables Empty After pg_upgrade (PG 9.2.0 beta 2)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group