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

_______________________________________________
rhelv5-list mailing list
rhelv5-list@(protected)
https://www.redhat.com/mailman/listinfo/rhelv5-list