Nagios Support Forum

# cd /var/lib/pgsql/data/pg_log # cat postgresql-Wed.log ERROR: left link changed unexpectedly in block 9 of index "xi_meta_keyname_idx" CONTEXT: automatic vacuum of table "nagiosxi.public.xi_meta" ERROR: left link changed unexpectedly in block 9 of index "xi_meta_keyname_i...

I am using Nagiosxi # cat /var/lib/pgsql/data/postgresql.conf # ----------------------------- # PostgreSQL configuration file # ----------------------------- # # This file consists of lines of the form: # # name = value # # (The "=" is optional.) Whitespace may be used. Comments are introd...

More Info [root@JLDTBVMIF08 scripts]# tail /var/log/mysqld.log 170405 15:02:54 [Note] /usr/libexec/mysqld: Shutdown complete 170405 15:02:54 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended 170405 15:06:00 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 170405 ...

service postgresql status postmaster is stopped ps aux USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.0 19364 1536 ? Ss Apr04 0:01 /sbin/init root 2 0.0 0.0 0 0 ? S Apr04 0:00 [kthreadd] root 3 0.0 0.0 0 0 ? S Apr04 0:10 [migration/0] root 4 0.0 0.0 0 0 ? S Apr04 0:02 [ksoftirq...

hello my Nagios PostgreSQL wont start # service postgresql restart Stopping postgresql service: [FAILED] Starting postgresql service: [FAILED] I try vacuum and it give me this # echo "vacuum;vacuum analyze;"|psql nagiosxi postgres psql: could not connect to server: No such file or director...