Re: Could not create a tablespace - permission denied

Graham Leggett wrote:

> After the postgres user was granted permission to access the tablespace 
> directory, and after it was verified that the postgres user was able to 
> access the tablespace directory, postgresql refused to allow the 
> tablespace to be created until the postgresql server was restarted.

I am pretty sure you are missing something. I can not reproduce your
issue:

jd@[EMAIL PROTECTED]
 mkdir /tmp/foo
jd@[EMAIL PROTECTED]
 psql -U postgres
postgres=# \h create tablespace
Command:     CREATE TABLESPACE
Description: define a new tablespace
Syntax:
CREATE TABLESPACE tablespacename [ OWNER username ] LOCATION 'directory'

postgres=# create tablespace foobar location '/tmp/foo';
ERROR:  could not set permissions on directory "/tmp/foo": Operation not 
permitted
postgres=#
[1]+  Stopped                 psql -U postgres
jd@[EMAIL PROTECTED]
 sudo su -
[sudo] password for jd:
root@[EMAIL PROTECTED]
 chown postgres:postgres /tmp/foo
root@[EMAIL PROTECTED]
 exit
logout
jd@[EMAIL PROTECTED]
 fg
psql -U postgres

postgres=# create tablespace foobar location '/tmp/foo';
CREATE TABLESPACE
postgres=#

But I am glad your problem is resolved.

Joshua D. Drake

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin