Re: Deadlock in postgresql
Posted: Wed May 04, 2016 1:09 pm
There may be a stuck Nagios process that is holding the postgres database causing the deadlock error.
Lets stop the Nagios and postgres daemons by logging to the server as root and running the following
Next, lets start the postgres database and vacuum it by running the following.
Now startup the Nagios daemon and see if that resolved the issue.
Lets stop the Nagios and postgres daemons by logging to the server as root and running the following
Code: Select all
service nagios stop
killall -9 nagios
service postgresql stopCode: Select all
service postgresql start
echo "vacuum;vacuum analyze;vacuum full;"|psql nagiosxi postgres
service postgresql restartCode: Select all
service nagios start