Re: Aother tablespace permission issue (was Re: Permission problem ...)

Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> ~$ 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

> 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

The specified directory has to be owned by the postgres operating system
user, not by anyone else. (The SQL-level notion of ownership is not
relevant --- the SQL owner might not correspond to any OS user at all.)

regards, tom lane