Error creating Tablespace on Windows

From: deepak <deepak(dot)pn(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Error creating Tablespace on Windows
Date: 2015-11-25 20:01:57
Message-ID: CAALYutfKK5X-p6FbgO1cO+PRQfns6=0u_1jO2SaLDxZUqRSPqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am getting this permission denied error on Windows 2008 trying to create
a tablespace.

template1=# create tablespace testtablespace location
'c:/windows/temp1/testtablespace';
ERROR: could not set permissions on directory
"c:/windows/temp1/testtablespace": Permission denied

If I use 'c:/windows/temp/testtablespace' for location, it works.

If I look at properties for c:/windows/temp and c:/windows/temp1, they look
identical (same ownership and read/write permissions).

Any thoughts on what else to check?

This is with Postgresql 9.1.9.

--
Deepak

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-11-25 20:15:00 Re: Error creating Tablespace on Windows
Previous Message Yuriy Rusinov 2015-11-25 19:18:34 Re: Convert from hex to string