Skip site navigation (1) Skip section navigation (2)

postgres 8.3 (Centos 5.1) create tablespace problem

From: "Nicholas Hemley" <nic(dot)hemley(at)sidonis(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: postgres 8.3 (Centos 5.1) create tablespace problem
Date: 2008-02-27 12:20:52
Message-ID: 000e01c8793b$3213f820$963be860$@hemley@sidonis.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2008-02-27 15:33:43
Subject: Re: postgres 8.3 (Centos 5.1) create tablespace problem
Previous:From: Scott FordDate: 2008-02-26 19:51:02
Subject: Foreign key violation

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group