Description

RealTimeMonitor PostgreSQL database startup troubleshooting

Symptoms

When trying to manually start RealTimeMonitor PostgreSQL database, it fails with the error messages "root execution of the PostgreSQL server is not permitted" in the server log.

Solution

Due to database security consideration, it is not allowed to start the PostgreSQL database as the operating system superuser "root" by running the generic RealTimeMonitor startup script "/usr/netscreen/RealtimeMt/startup/glproServer" directly.

Instead of using the generic RealTimeMonitor startup script "/usr/netscreen/RealtimeMt/startup/glproServer" directly, run the following system startup script as the superuser "root" to stop or/and start the PostgreSQL process:

' ' ' ' ' ' ' ' '  /etc/rc3.d/S91glproServer stop

' ' ' ' ' ' ' ' '  /etc/rc3.d/S91glproServer start

The difference between this script and the generic RealTimeMonitor startup script'  is that this script will perform an operating system user-switching ("su - realtime") to change the process owner ID from "root" to "realtime" which is the preconfigured RealTimeMonitor system user.


Former Article Id

nskb3686