Graham Leggett wrote:
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
--
I'd check that the user postgresql is running as can create files in
/home/chandler/fma/db/pgsql
# assuming postgres is the user
su - postgres
touch /home/chandler/fma/db/pgsql/foo
rm /home/chandler/fma/db/pgsql/foo
Hugh
_______________________________________________
rhelv5-list mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/rhelv5-list
