Could not create a tablespace - permission denied

Поиск
Список
Период
Сортировка
От Graham Leggett
Тема Could not create a tablespace - permission denied
Дата
Msg-id 4809EC7B.6060902@sharp.fm
обсуждение исходный текст
Ответы Re: Could not create a tablespace - permission denied  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi all,

While attempting to create a tablespace as the postgres user under RHEL5
with *no* SELinux enabled, I get the following error:

postgres=# CREATE TABLESPACE fma LOCATION '/home/chandler/fma/db/pgsql';
ERROR:  could not set permissions on directory
"/home/chandler/fma/db/pgsql": Permission denied

The user postgres is able to access the directory, and the user postgres
is able to set permissions on the directory to 0700:

-bash-3.1$ chmod 700 /home/chandler/fma/db/pgsql
-bash-3.1$

Does anyone know what I should do to fix this?

Regards,
Graham
--

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Jaisen N.D."
Дата:
Сообщение: Re: Re: Problem:- createdb: could not connect to database postgres: could not connect to server: No such file or directory
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Could not create a tablespace - permission denied