Page 1 of 1

Postgres to mysql

Posted: Tue Jun 05, 2018 9:18 am
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?

Re: Postgres to mysql

Posted: Tue Jun 05, 2018 2:57 pm
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

Re: Postgres to mysql

Posted: Wed Jun 06, 2018 2:56 am
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

Re: Postgres to mysql

Posted: Wed Jun 06, 2018 12:16 pm
by BanditBBS
Sure will @WillemDH

Might be a few til I do it, have to write CMRs and such.

Re: Postgres to mysql

Posted: Wed Jun 06, 2018 1:11 pm
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.