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

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 (view raw or flat)
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

pgsql-bugs by date

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

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