postgres 8.3 (Centos 5.1) create tablespace problem - Mailing list pgsql-novice

From Nicholas Hemley
Subject postgres 8.3 (Centos 5.1) create tablespace problem
Date
Msg-id 000e01c8793b$3213f820$963be860$@hemley@sidonis.com
Whole thread Raw
Responses Re: postgres 8.3 (Centos 5.1) create tablespace problem
List pgsql-novice

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

pgsql-novice by date:

Previous
From: "Scott Ford"
Date:
Subject: Foreign key violation
Next
From: Tom Lane
Date:
Subject: Re: postgres 8.3 (Centos 5.1) create tablespace problem