The following bug has been logged online: Bug reference: 5752 Logged by: Kasia Tuszynska Email address: ktuszyn...@esri.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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
