Could not create a tablespace - permission denied - Mailing list pgsql-admin

From Graham Leggett
Subject Could not create a tablespace - permission denied
Date
Msg-id 4809EC7B.6060902@sharp.fm
Whole thread Raw
Responses Re: Could not create a tablespace - permission denied
List pgsql-admin
Hi all,

While attempting to create a 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$

Does anyone know what I should do to fix this?

Regards,
Graham
--

Attachment

pgsql-admin by date:

Previous
From: "Jaisen N.D."
Date:
Subject: Re: Re: Problem:- createdb: could not connect to database postgres: could not connect to server: No such file or directory
Next
From: Tom Lane
Date:
Subject: Re: Could not create a tablespace - permission denied