Re: Error creating Tablespace on Windows

I chose temp only for illustration purposes. Actually the regression test
"tablespace" fails too,
for the same reason, when run from sources (which creates a tablespace
directory under
src/test/regress)

--
Deepak

On Wed, Nov 25, 2015 at 2:15 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 11/25/2015 12:01 PM, deepak wrote:
>
>> 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
>>
>
>
> why are you putting database tables in the Windows directory?!? I would
> instead put them somewhere like
>
> C:\Users\postgres\AppData\Local\Temp (assuming C:\Users\postgres is the
> %USERPROFILE% directory for the postgres service owner...)
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>