Postgres to mysql

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Postgres to mysql

Post by BanditBBS »

Was a script ever released to get rid of the postgres DB for installations that are old and just keep upgrading to latest version?
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
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Postgres to mysql

Post by tgriep »

Are you looking for the instructions for migrating the nagiosxi Postgres database to MYSQL?
If so, the following link is the KB article with instructions for doing the conversion.
https://support.nagios.com/kb/article/c ... i-560.html
Be sure to check out our Knowledgebase for helpful articles and solutions!
User avatar
WillemDH
Posts: 2320
Joined: Wed Mar 20, 2013 5:49 am
Location: Ghent
Contact:

Re: Postgres to mysql

Post by WillemDH »

Hello,

We also still need to achieve this. Is there any performance enhancement after consolidating the db's into mysql?

@Bandit

Please let us know how it works our for you. :)

Grtz

Willem
Nagios XI 5.8.1
https://outsideit.net
User avatar
BanditBBS
Posts: 2474
Joined: Tue May 31, 2011 12:57 pm
Location: Scio, OH
Contact:

Re: Postgres to mysql

Post by BanditBBS »

Sure will @WillemDH

Might be a few til I do it, have to write CMRs and such.
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
User avatar
tgriep
Madmin
Posts: 9190
Joined: Thu Oct 30, 2014 9:02 am

Re: Postgres to mysql

Post by tgriep »

I haven't heard either way about the performance after anyone doing the migration so it is hard to say if it did change.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked