[ADMIN] Could not create a tablespace - permission denied

[Graham Leggett]

Hi all,




postgres=# CREATE TABLESPACE fma LOCATION '/home/chandler/fma/db/pgsql';




-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
--

While attempting to create a tablespace as the postgres user under RHEL5 with *no* SELinux enabled, I get the following error: 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:

smime.p7s
Description: S/MIME Cryptographic Signature