[linux] PostgreSQL Error on Red Hat EL 5.5 - Any suggestions?

[Joshua Daniel Franklin]

  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,
Joshua


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,

>

> Michalis

> Geography