trouble creating a tablespace on win2k8r2 with pg9.0

From: Kasia Tuszynska <ktuszynska(at)esri(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: trouble creating a tablespace on win2k8r2 with pg9.0
Date: 2010-11-09 18:14:23
Message-ID: 232B5217AD58584C87019E8933556D11021A1E3B03@redmx2.esri.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael O'Donnell 2010-11-09 19:21:35 PostgreSQL Windows 8.4 tablespaces on remote servers
Previous Message Alvaro Herrera 2010-11-08 22:09:31 Re: autovacuum launcher process eating up 17G+ of ram?