BUG #5752: installer does not give proper os privileges on folders

From: "Kasia Tuszynska" <ktuszynska(at)esri(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5752: installer does not give proper os privileges on folders
Date: 2010-11-13 00:27:47
Message-ID: 201011130027.oAD0RlZf001164@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5752
Logged by: Kasia Tuszynska
Email address: ktuszynska(at)esri(dot)com
PostgreSQL version: 9.0.1
Operating system: Windows 2008 R2 (64bit)
Description: installer does not give proper os privileges on folders
Details:

Tested:
The one click Postgres 64bit installer for 9.0.0 and 9.0.1

Tested on:
windows 2008 64bit
windows 2008 R2 - which is only 64bit
UAC was turned off
password strength was disabled

Problem: crying to create a tablespace gives error: could not set
permissions on directory C:\.....\tablespace_name" Permission denied

work around: grant the users group full control privileges on the tablespace
folder

Locations tried:
under the data folder - failed with permissions denied
under the C drive - failed with permissions denied

ways of creating ta tablespace, tried:
programatically calling a postgres function
creating folder manually, using pgAdminiii for tbsp creation
creating folder manually, using psql to create the tablespace

Compared the result:
pg 8.3.8 msi on win2003 32bit, win 2008 R2
to
pg 9.0.0 and 9.0.1 one click installer on win 2008 R2

I compared the privileges granted on the PostgreSQL, 8.3/9.0, data and
tablespace folders and found the following differences:
PostgreSQL folder - same privs given by both versions

Privs present on the 8.3.8 folder but missing on the 9.0 folder
deny postgres special
allow postgers read&execute
- all others are the same between both versions

Priv differences on the data folder
8.3.8 had:
allow postgres modify not inherited this folder and subfolders

9.0 had:
allow postgres special not inherited this folder only
allow kasia special not inherited this folder only
- all others are the same between both versions

Privs listed on the folder data\tablespace_name
8.3.8:
allow trustedinstaller special - appears twice
allow system special - appears twice
allow administrators special - appears twice
allow users special - appears twice
allow creator owner special
allow postgres modify this folder, subfolders

9.0:
allow trustedinstaller special
allow system full control
allow administrators full control
allow users read&write
allow creator owner special

Conclusion: postgres os user and the users windows group are missing
privileges on folders granted inside the data folder layed down by the
postgres 9.0 one click installer.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-11-13 03:29:55 Re: WARNING: 01000: could not dump unrecognized node type: 928
Previous Message Jon Nelson 2010-11-12 22:39:56 WARNING: 01000: could not dump unrecognized node type: 928