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
rhelv5-list@(protected)
https://www.redhat.com/mailman/listinfo/rhelv5-list