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
Views: Raw Message | Whole Thread | Download mbox
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

Browse pgsql-admin by date

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