From: Graham Leggett <minfrin@sharp.fm>
To: pgsql-admin@postgresql.org
Subject: Could not create a tablespace - permission denied
Date: Sat, 19 Apr 2008 14:58:35 +0200
Message-ID: <4809EC7B.6060902@sharp.fm> (raw)
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
--
Attachments:
smime.p7s (application/x-pkcs7-signature, 3.2K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: minfrin@sharp.fm
Subject: Re: Could not create a tablespace - permission denied
In-Reply-To: <4809EC7B.6060902@sharp.fm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox