Page 1 of 1
Restore postgresql!!!!!
Posted: Wed Apr 29, 2015 8:06 am
by BanditBBS
Hey, one of my team is an idiot and changed everyone's notificaiton settings. That is stored in the backup of the postgresql db, right? Whats the procedure to restore just that?
Also, that wont screw up any dashboards will it?
Re: Restore postgresql!!!!!
Posted: Wed Apr 29, 2015 9:54 am
by jolson
Hey, one of my team is an idiot and changed everyone's notificaiton settings. That is stored in the backup of the postgresql db, right? Whats the procedure to restore just that?
Which notification settings are talking about exactly? It's possible that they're stored in the MySQL database, in which case we could simply restore a table or two.
Were the settings described in the below screenshot affected?
2015-04-29 09_52_18-Nagios XI - Nagios Core Config Manager.png
Re: Restore postgresql!!!!!
Posted: Wed Apr 29, 2015 9:58 am
by BanditBBS
The XI users settings: The notification methods(email, mobile txt, sms) and preferences tab.
Re: Restore postgresql!!!!!
Posted: Wed Apr 29, 2015 10:13 am
by abrist
it is easiest to restore the db from the newest nagiosxi backup (as the daily cron backups do not have all the necessary drop sequences that the full XI backup does).
Expand a nagios XI backup tarball, descend into the pgsql directory of the the expanded archive, and then run:
Code: Select all
psql -U nagiosxi nagiosxi < nagiosxi.sql
You may want to run a nagiosxi backup first just in case.
BanditBBS wrote:
Also, that wont screw up any dashboards will it?
It *should* not effect them - they should be restored to the state in the backup.
Re: Restore postgresql!!!!!
Posted: Wed Apr 29, 2015 10:40 am
by BanditBBS
abrist wrote:it is easiest to restore the db from the newest nagiosxi backup (as the daily cron backups do not have all the necessary drop sequences that the full XI backup does).
Expand a nagios XI backup tarball, descend into the pgsql directory of the the expanded archive, and then run:
Code: Select all
psql -U nagiosxi nagiosxi < nagiosxi.sql
You may want to run a nagiosxi backup first just in case.
BanditBBS wrote:
Also, that wont screw up any dashboards will it?
It *should* not effect them - they should be restored to the state in the backup.
I love you.....wait...I mean thank you very much! Done and worked...now to yell at someone!
Re: Restore postgresql!!!!!
Posted: Wed Apr 29, 2015 11:03 am
by abrist
Awesome, just remember to use compliment sandwiches when yelling at your staff:
[compliment]
[yelling]
[compliment]
...
[beer?]
Re: Restore postgresql!!!!!
Posted: Fri May 01, 2015 9:15 am
by vAJ
Where's the like or LMAO button in phpBB?
Re: Restore postgresql!!!!!
Posted: Fri May 01, 2015 9:18 am
by tmcdonald
BanditBBS wrote:abrist wrote:it is easiest to restore the db from the newest nagiosxi backup (as the daily cron backups do not have all the necessary drop sequences that the full XI backup does).
Expand a nagios XI backup tarball, descend into the pgsql directory of the the expanded archive, and then run:
Code: Select all
psql -U nagiosxi nagiosxi < nagiosxi.sql
You may want to run a nagiosxi backup first just in case.
BanditBBS wrote:
Also, that wont screw up any dashboards will it?
It *should* not effect them - they should be restored to the state in the backup.
I love you.....wait...I mean thank you very much! Done and worked...now to yell at someone!
New shirt for this year's conference.