Converting PostgreSQL to MySQL

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
TBT
Posts: 625
Joined: Wed May 18, 2011 1:26 pm

Converting PostgreSQL to MySQL

Post by TBT »

As we progress with our upgrade and migration from 5.6 to 5.7 and then to 5.8, we'd like to convert the old Postgres DB to MySQL, keeping mind that all other Databases associated with XI have been offloaded.

1. Is this still the process for Converting PostgreSQL to MySQL for Nagios XI?
https://support.nagios.com/kb/article/c ... i-560.html

2. We assume offloading this Database is acceptable?
Nagios XI 2024R2.2.1 (8 Servers)
Nagios Fusion 2024R1.0.2
gsmith
Posts: 1253
Joined: Tue Mar 02, 2021 11:15 am

Re: Converting PostgreSQL to MySQL

Post by gsmith »

Hi

1. Yes, to convert PostgreSQL to mysql use:
https://support.nagios.com/kb/article/c ... i-560.html

2. Yes, offloading the database is aceptable. Here is a document to help you do so:
https://assets.nagios.com/downloads/nag ... Server.pdf

Thanks!
Locked