Message-ID: <480A1A55.6090800@commandprompt.com>
Date: Sat, 19 Apr 2008 09:14:13 -0700
From: "Joshua D. Drake" <jd@commandprompt.com>
Organization: Command Prompt, Inc.
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
To: Graham Leggett <minfrin@sharp.fm>
CC: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-admin@postgresql.org
Subject: Re: Could not create a tablespace - permission denied
References: <4809EC7B.6060902@sharp.fm> <9189.1208619241@sss.pgh.pa.us>
	<480A12F5.5060609@sharp.fm> <9478.1208620229@sss.pgh.pa.us>
	<480A190B.80408@sharp.fm>
In-Reply-To: <480A190B.80408@sharp.fm>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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@scratch:~$ mkdir /tmp/foo
jd@scratch:~$ 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@scratch:~$ sudo su -
[sudo] password for jd:
root@scratch:~# chown postgres:postgres /tmp/foo
root@scratch:~# exit
logout
jd@scratch:~$ 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