[linux] PostgreSQL Error on Red Hat EL 5.5 - Any suggestions?
whelan at nb.uw.edu
Mon Jul 12 09:41:20 PDT 2010
If it only works with SELinux off then you can make a policy module to
allow whatever postgre is doing. The process is a bit laborious as you
typically have to keep allowing things a bit at a time until SELinux
stops complaining. Instructions can be found here (Note: this will only
work if you have the right tools installed; RHEL5 comes with them by
Look for the Q: entitled "I have some avc denials that I would like to
allow, how do I do this?".
I've done this with a different package (Cyrus-IMAP) and it will
eventually work if you keep at it. Let me know if you're interested in
NESAC/BIO Senior Computer Specialist
Department of Bioengineering
University of Washington
Phone: (206) 616-8187
On 7/9/10 1:39 PM, Joshua Daniel Franklin wrote:
> Hi Michalis,
> You should run this command as root:
> /sbin/service postgresql start
> That allows system bookkeeping such as active
> pids; the script in /etc/init.d/ switch to
> running the db as postgres user automatically.
> Hope it helps,
> On 7/9/10 [9 Jul] 1:02 PM, Michalis Avraam wrote:
>> Dear all,
>> A development server that has gone unused for a few months is acting
>> up now that it is needed. I am trying to run the installed PostgreSQL
>> (8.3.10) on it, but for some reason it fails to start. PostgreSQL was
>> successfully running for quite a while apparently, with no changes to
>> it done. Here is what I do:
>> postgres# /sbin/service postgresql start
>> [ FAIL ]
>> Contents of log file:
>> runuser: cannot set groups: Operation not permitted
>> If the same operation is run again through root, it runs fine, only if
>> SELinux is disabled (which is not desired).
>> Any suggestions on how to correct this behavior so PostgreSQL can run
>> with SELinux enforcing?
>> Thank you in advance,
More information about the Linux