Permission problem with create tablespace

Поиск
Список
Период
Сортировка
От Andras Simon
Тема Permission problem with create tablespace
Дата
Msg-id 9008cd5d0610161806i6770546i368e73187108ddb5@mail.gmail.com
обсуждение исходный текст
Ответы Re: Permission problem with create tablespace  (Douglas McNaught <doug@mcnaught.org>)
Re: Permission problem with create tablespace  ("Leonel Nunez" <lnunez@enelserver.com>)
Re: Permission problem with create tablespace  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I'm trying to create a new tablespace in a directory that postgres
owns, but PG says it cannot  set permissions on this directory.

[root@localhost ~]# su - postgres
-bash-3.1$ mkdir /opt/home/pgdata/mspace/
-bash-3.1$ psql
Welcome to psql 8.1.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

postgres=# CREATE TABLESPACE mspace LOCATION '/opt/home/pgdata/mspace';
ERROR:  could not set permissions on directory
"/opt/home/pgdata/mspace": Permission denied
postgres=# \q
-bash-3.1$ chmod 700 /opt/home/pgdata/mspace/
-bash-3.1$ whoami
postgres
-bash-3.1$

This is on Fedora Core 5 (x86), psql 8.1.4.

Andras

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_locks: who is locking ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Anyone using "POSIX" time zone offset capability?