Hi Everybody,
I am experimenting with Postgres 9.0 64bit on windows 2008 R2 server (64bit).
I am having trouble creating a tablespace, I have a very strong suspicion that my problems are windows specific, but I ran out of ideas of what else to try.
I create a folder under the PostgreSQL\data folder to be used for the tablespace
I go to pgADMIN III or psql and try to create the tablespace using the precreated folder, in both cases I get some version of this:
postgres=# CREATE TABLESPACE kasia OWNER bill LOCATION 'C:/Program Files/PostgreSQL/9.0/data/kasia';
ERROR: could not set permissions on directory "C:/Program Files/PostgreSQL/9.0/
data/kasia": Permission denied
Privileges on the folder:
- Postgres user has full control
- Admin users have full control
I have tried to following:
- Turn off UNC
- Make the whole PostgreSQL folder writable
- Grant explicit privileges to my os user (part of admin group) on the precreated folder
So far I am unsuccessful, I tried this on another win2k8 r2 machine and granting explicit privileges to my os user worked, so there is some difference between the machines in security settings but I am just not able to determine them.
Has anyone else ran in to this issue?
Thanks,
Sincerely,
Kasia