Skip site navigation (1) Skip section navigation (2)

Re: BUG #1488: CREATE TABLESPACE does not work

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Jesper Udby <jesper_pg(at)judby(dot)dk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1488: CREATE TABLESPACE does not work
Date: 2005-02-21 18:55:02
Message-ID: 200502211855.j1LIt2f09361@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Jesper Udby wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      1488
> Logged by:          Jesper Udby
> Email address:      jesper_pg(at)judby(dot)dk
> PostgreSQL version: 8.0.1
> Operating system:   Win32 XP Pro SP2
> Description:        CREATE TABLESPACE does not work
> Details: 
> 
> Hello.
> 
> Trying to create a tablespace fails with msg "ERROR:  could not set
> permissions on directory "...": Permission denied".
> 
> E.g. 
> 
> CREATE TABLESPACE pgtest LOCATION 'c:\\pgtest';
> 
> (Directory c:\\pgtest exists and is readable etc.)

My bet is that the owner of the directory is not the same as the owner
of the pg server.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2005-02-21 19:47:03
Subject: Re: BUG #1488: CREATE TABLESPACE does not work
Previous:From: Richard HuxtonDate: 2005-02-21 17:14:06
Subject: Re: BUG #1487: Index problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group