Aother tablespace permission issue (was Re: Permission problem ...) - Mailing list pgsql-general

From Ron Johnson
Subject Aother tablespace permission issue (was Re: Permission problem ...)
Date
Msg-id 45344676.2070206@cox.net
Whole thread Raw
In response to Re: Permission problem with create tablespace  (Douglas McNaught <doug@mcnaught.org>)
Responses Re: Aother tablespace permission issue (was Re: Permission problem ...)
List pgsql-general
On 10/16/06 20:17, Douglas McNaught wrote:
> "Andras Simon" <szajmi@gmail.com> writes:
>
>> I'm trying to create a new tablespace in a directory that postgres
>> owns, but PG says it cannot  set permissions on this directory.
>
> ...
>
>> This is on Fedora Core 5 (x86), psql 8.1.4.
>
> SELinux, most likely.

In my case, it is *not* SELinux, since I'm not running it...

Debian Sid
PostgreSQL 8.1.5 (distro version 8.1.5-1)

As you can see from the attached file, user "me" is a Superuser and
is a member of group postgres, and *is* able to create files in that
directory.

File /var/log/postgresql/postgresql-8.1-main.log gives the same
error that psql does, and there's nothing in syslog.

Any help appreciated.

--
Ron Johnson, Jr.
Jefferson LA  USA

Is "common sense" really valid?
For example, it is "common sense" to white-power racists that
whites are superior to blacks, and that those with brown skins
are mud people.
However, that "common sense" is obviously wrong.

~$ dir /data/02/share | grep datab
  drwxrwxr-x  2 me   postgres  4096 2006-10-16 21:38 database/

~$ touch /data/02/share/database/testing.testing
~$ dir /data/02/share/database
total 8
drwxrwxr-x  2 me postgres 4096 2006-10-16 21:53 ./
drwxrwxr-x 16 me people   4096 2006-10-16 21:38 ../
-rw-r--r--  1 me me          0 2006-10-16 21:53 testing.testing

$ psql -U me dupe_filenames
Welcome to psql 8.1.5, 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

dupe_filenames=# \du
                               List of roles
 Role name | Superuser | Create role | Create DB | Connections | Member of
-----------+-----------+-------------+-----------+-------------+-----------
 me        | yes       | yes         | yes       | no limit    |
 postgres  | yes       | yes         | yes       | no limit    |
(2 rows)

dupe_filenames=# create tablespace thisisatest
dupe_filenames-# owner me
dupe_filenames-# location '/data/02/share/database';
ERROR:  could not set permissions on directory "/data/02/share/database": Operation not permitted

Attachment

pgsql-general by date:

Previous
From: "Carlos H. Reimer"
Date:
Subject: RES: RES: RES: RES: Dates rejected
Next
From: "Carlos H. Reimer"
Date:
Subject: RES: RES: RES: RES: Dates rejected