Nagios Support Forum

Linux Distribution and version?
1. Cent OS 6.2 / 64 Bit
2. Manual Install
3. Gnome installed

To Nagios XI Tech Support Specialist:

Now I am getting this....


DB Connect Error [nagiosxi]: Database connection failed SQL: SQL Error [nagiosxi] : Database connection failed SQL: SQL Error [nagiosxi] : Database connection failed DB Connect Error [nagiosxi]: Database connection failed DB Connect Error [nagiosxi]: Database connection failed

Can you run the following from the command prompt If that fails lets run and return the results

Also, we may need to run

Last login: Thu Dec 20 23:13:38 2012
[root@fldmon ~]# service postgresql start
Starting postgresql service: [ OK ]
[root@fldmon ~]#

Last login: Thu Dec 20 23:13:38 2012
[root@fldmon ~]# service postgresql start
Starting postgresql service: [ OK ]
[root@fldmon ~]# Last login: Thu Dec 20 23:13:38 2012
-bash: Last: command not found
[root@fldmon ~]# [root@fldmon ~]# service postgresql start
-bash: [root@fldmon: command not found
[root@fldmon ~]# Starting postgresql service: [ OK ]
-bash: Starting: command not found
[root@fldmon ~]# [root@fldmon ~]#
[root@fldmon ~]# echo "vacuum;vacuum analyse;vacuum full;"|psql nagiosxi postgres
psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".
[root@fldmon ~]# echo "vacuum;vacuum analyse;vacuum full;"|psql nagiosfusion postgres
psql: FATAL: database "nagiosfusion" does not exist
[root@fldmon ~]# echo "vacuum;vacuum analyse;vacuum full;"|psql postgres postgres
psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".
[root@fldmon ~]# echo "vacuum;vacuum analyse;vacuum full;"|psql template1 postgres
psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".
You have new mail in /var/spool/mail/root
[root@fldmon ~]#

I believe this is related to this wiki
http://support.nagios.com/wiki/index.ph ... .22_in_log

[root@fldmon ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
265G 114G 137G 46% /
/dev/sda1 99M 13M 81M 14% /boot
tmpfs 7.9G 0 7.9G 0% /dev/shm
tmpfs 50M 7.5M 43M 15% /var/nagiosramdisk
You have new mail in /var/spool/mail/root
[root@fldmon ~]#

The wiki does not seem to help:

[root@fldmon ~]# psql nagiosxi nagiosxi
psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".
You have new mail in /var/spool/mail/root
[root@fldmon ~]# VACUUM;
-bash: VACUUM: command not found
[root@fldmon ~]# psql nagiosxi nagiosxi
psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".
[root@fldmon ~]# VACUUM;
-bash: VACUUM: command not found
[root@fldmon ~]# VACUUM ANALYZE;
-bash: VACUUM: command not found
[root@fldmon ~]# VACUUM FULL;
-bash: VACUUM: command not found
[root@fldmon ~]# \q
-bash: q: command not found
[root@fldmon ~]# psql postgres postgres
psql: FATAL: database is not accepting commands to avoid wraparound data loss in database "postgres"
HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".
[root@fldmon ~]# VACUUM;
-bash: VACUUM: command not found
[root@fldmon ~]# VACUUM ANALYZE;
-bash: VACUUM: command not found
[root@fldmon ~]# VACUUM FULL;
-bash: VACUUM: command not found
[root@fldmon ~]# \q
-bash: q: command not found
[root@fldmon ~]# VACUUM FULL;
-bash: VACUUM: command not found
You have new mail in /var/spool/mail/root
[root@fldmon ~]# VACUM FULL;
-bash: VACUM: command not found
[root@fldmon ~]#

What does this mean and how do i stop it???

HINT: Stop the postmaster and use a standalone backend to vacuum database "postgres".

I am still getting this after all the solutions that was suggested to me:

DB Connect Error [nagiosxi]: Database connection failed SQL: SQL Error [nagiosxi] : Database connection failed SQL: SQL Error [nagiosxi] : Database connection failed DB Connect Error [nagiosxi]: Database connection failed DB Connect Error [nagiosxi]: Database connection failed