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

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Basil Peace <grv87(at)yandex(dot)ru>
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:07:26
Message-ID: CA+OCxowB2GEtevP2=sF621Aud1o-9Hx2QHE=D187VS00xS2Kcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jun 6, 2012 at 8:04 PM, Basil Peace <grv87(at)yandex(dot)ru> wrote:
> 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.

That's supposed to happen. It sets the permissions on the data
directory and then recurses back up to the root directory, ensuring
the postgres account is able to read all the parent directories -
otherwise, even if it has write permissions on the data directory
itself, it cannot access it.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tomonari Katsumata 2012-06-07 01:46:11 Re: BUG #6676: checkpointer does not work by SIGINT.
Previous Message Basil Peace 2012-06-06 19:04:39 Re: BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder