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$ (view raw, whole thread or download thread mbox)
Lists: pgsql-novice


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?


Any ideas?





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-2018 The PostgreSQL Global Development Group