Skip site navigation (1) Skip section navigation (2)

Re: Could not create a tablespace - permission denied

From: Graham Leggett <minfrin(at)sharp(dot)fm>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Could not create a tablespace - permission denied
Date: 2008-04-19 15:42:45
Message-ID: 480A12F5.5060609@sharp.fm (view raw or flat)
Thread:
Lists: pgsql-admin
Tom Lane wrote:

> If you can do that from a shell running as postgres, then I think
> selinux is not so disabled as you think.  Ordinary file permissions are
> applied uniformly to all processes running as a given userid, but
> selinux is different.

SELinux is definitely not present on this machine - it is not installed 
at all.

At it turned out, the postgresql server had cached the system user 
permissions, and it only started working after postgresql had been 
restarted and the cached credentials had been replaced.

Regards,
Graham
--

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-04-19 15:50:29
Subject: Re: Could not create a tablespace - permission denied
Previous:From: Tom LaneDate: 2008-04-19 15:34:01
Subject: Re: Could not create a tablespace - permission denied

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group