Page 1 of 1

nagiosxi 2.4 upgrade - PostgresSQL error

Posted: Tue May 01, 2012 3:48 pm
by sal@coned
I am attempting to upgrade from Nagios XI 2011R2.3 to 2.4
I get an PostgresSQL error when I run the upgrade script (the system upgraded successfully from 2.2 to 2.3).
I have downloaded both the xi-latest.tar.gz and the xi-2011r2.4.tar.gz and get the same error when I run the upgrade script.

This is the error I get:
[root@nagios-hq-1 nagiosxi]# ./upgrade
Checking PostgresQL status...
ERROR: PostgresQL not running - exiting.

When I check the status of PostgresSQL it says its running
[root@nagios-hq-1 tmp]# /etc/init.d/postgresql status
postmaster (pid 16236 16125 16118 16113 16112 4322 4313 4299 4278 4274 4258 4255 4227 4224 4220 4193 4154 4057 4056 4055 4053 3877) is running...
[root@nagios-hq-1 tmp]#

I updaded the system using the "yum --skip-broken upgrade" command to make sure the system was up to date, and rebooted the machine, same error when running upgrade.


Any Ideas?

Re: nagiosxi 2.4 upgrade - PostgresSQL error

Posted: Tue May 01, 2012 4:06 pm
by scottwilkerson
Our file init-auditlog is running a test on postgres based on

Code: Select all

service postgresql status
If you edit init-auditlog on line 9 change

Code: Select all

if service postgresql status &>/dev/null; then
to

Code: Select all

if /etc/init.d/postgresql status &>/dev/null; then
It should work fine.

Re: nagiosxi 2.4 upgrade - PostgresSQL error

Posted: Wed May 02, 2012 9:48 am
by sal@coned
Thanks for the information.

I did a little more checking and the line was failing because the "/sbin/" directory was not in the search path.
running "export PATH=$PATH:/sbin" got the service command to work.

Again, thanks for the help

Sal