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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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