postgres 8.3 (Centos 5.1) create tablespace problem

Поиск
Список
Период
Сортировка
От Nicholas Hemley
Тема postgres 8.3 (Centos 5.1) create tablespace problem
Дата
Msg-id 000e01c8793b$3213f820$963be860$@hemley@sidonis.com
обсуждение исходный текст
Ответы Re: postgres 8.3 (Centos 5.1) create tablespace problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Scott Ford"
Дата:
Сообщение: Foreign key violation
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postgres 8.3 (Centos 5.1) create tablespace problem