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
I am unable to create a tablespace both in pgadmin3 and via psql with the
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?
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2008-02-27 15:33:43|
|Subject: Re: postgres 8.3 (Centos 5.1) create tablespace problem |
|Previous:||From: Scott Ford||Date: 2008-02-26 19:51:02|
|Subject: Foreign key violation|