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:
[EMAIL PROTECTED]:~$ mkdir /tmp/foo
[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
[EMAIL PROTECTED]:~$ sudo su -
[sudo] password for jd:
[EMAIL PROTECTED]:~# chown postgres:postgres /tmp/foo
[EMAIL PROTECTED]:~# exit
logout
[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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin