Ron Johnson <ron.l.johnson@xxxxxxx> 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
