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?
Restore postgresql!!!!!
Restore postgresql!!!!!
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
Re: Restore postgresql!!!!!
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.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?
Were the settings described in the below screenshot affected?
You do not have the required permissions to view the files attached to this post.
Re: Restore postgresql!!!!!
The XI users settings: The notification methods(email, mobile txt, sms) and preferences tab.
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
Re: Restore postgresql!!!!!
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:
You may want to run a nagiosxi backup first just in case.
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.sqlIt *should* not effect them - they should be restored to the state in the backup.BanditBBS wrote: Also, that wont screw up any dashboards will it?
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Re: Restore postgresql!!!!!
I love you.....wait...I mean thank you very much! Done and worked...now to yell at someone!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:You may want to run a nagiosxi backup first just in case.Code: Select all
psql -U nagiosxi nagiosxi < nagiosxi.sqlIt *should* not effect them - they should be restored to the state in the backup.BanditBBS wrote: Also, that wont screw up any dashboards will it?
2 of XI5.6.14 Prod/DR/DEV - Nagios LogServer 2 Nodes
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
See my projects on the Exchange at BanditBBS - Also check out my Nagios stuff on my personal page at Bandit's Home and at github
Re: Restore postgresql!!!!!
Awesome, just remember to use compliment sandwiches when yelling at your staff:
[compliment]
[yelling]
[compliment]
...
[beer?]
[compliment]
[yelling]
[compliment]
...
[beer?]
Former Nagios employee
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
"It is turtles. All. The. Way. Down. . . .and maybe an elephant or two."
VI VI VI - The editor of the Beast!
Come to the Dark Side.
Re: Restore postgresql!!!!!
New shirt for this year's conference.BanditBBS wrote:I love you.....wait...I mean thank you very much! Done and worked...now to yell at someone!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:You may want to run a nagiosxi backup first just in case.Code: Select all
psql -U nagiosxi nagiosxi < nagiosxi.sqlIt *should* not effect them - they should be restored to the state in the backup.BanditBBS wrote: Also, that wont screw up any dashboards will it?
Former Nagios employee