Page 2 of 2
Re: Postgresql Will Not Start
Posted: Thu May 10, 2012 3:19 pm
by 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.
Re: Postgresql Will Not Start
Posted: Thu May 10, 2012 3:55 pm
by 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
Re: Postgresql Will Not Start
Posted: Fri May 11, 2012 9:54 am
by 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
Re: Postgresql Will Not Start
Posted: Fri May 11, 2012 11:06 am
by 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.