Postgresql Will Not Start

[easy2kent]

Same error as before: psql: FATAL: could not open relation 1663/16385/1259: Permission denied

So it doesn't seem to have the permissions for nagiosxi user but I do not know how to set those.

[scottwilkerson]

Sounds correct, we are going to have to rebuild your postgres database as it appeard that some of the data you lost was in there...

Code: Select all

cd /tmp
rm -rf nagiosxi xi-latest*
wget http://assets.nagios.com/downloads/nagiosxi/xi-latest.tar.gz
tar xzf xi-latest.tar.gz
cd /tmp/nagiosxi
rm -f installed.postgresql
./init-postgres
./init-xidb

[easy2kent]

This worked!! Thank you. I was able to recover my Nagios data with minimal data loss. I had to go through and change some of the settings (i.e. users, passwords and system credentials) but the data from the checks was still there.

Thanks to the both of you,
Kent

[scottwilkerson]

Awesome.

You likely will have to re-setup any users you have and their settings but that's all, the rest of the data is stored in mysql.