Hi all,

While attempting to create a postgresql tablespace as the postgres user under RHEL5 with *no* SELinux enabled, I get the following error:

postgres=# CREATE TABLESPACE fma LOCATION '/home/chandler/fma/db/pgsql';
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:

-bash-3.1$ chmod 700 /home/chandler/fma/db/pgsql
-bash-3.1$

When I first encountered this problem, the only solution I could find was to blow away postgres and reinstall the databases from scratch. Now that one database is live, this is no longer an option.

Does anyone know for sure whether postgres tablespaces are known to work at all on the RHEL5 platform?

Regards,
Graham
--

Attachment: smime.p7s
Description: S/MIME Cryptographic Signature

_______________________________________________
rhelv5-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/rhelv5-list

Reply via email to