Hello,
I am trying to create a new tablespace using postgres 8.3 (Centos 5.1) and am getting a permissions problem when trying to do so.
Basically, the directory is owned by postgres and full permissions are granted.
I am unable to create a tablespace both in pgadmin3 and via psql with the following:
CREATE TABLESPACE "tablespace" OWNER nic LOCATION '/home/nic/tablespace';
Where the user nic is set-up as a login role and the directory exists.
The postgres user is able to read/write/execute in the specified directory, so what am i missing here?
Any ideas?
Cheerio,
Nic
__________ Information from ESET Smart Security, version of virus signature database 2905 (20080227) __________
The message was checked by ESET Smart Security.
http://www.eset.com