The DB migration from MySQL to PgSQL involves taking a PgSQL compatible backup, re-installing the product with PgSQL database and restoring the backup.
The procedure for the above is a little tedious and time consuming in version 9 & 10. So, please upgrade your current installation to the 11 and then follow the steps to migrate the DB. The upgrade packs & instructions can be found in this link
Steps to migrate from MySQL to PgSQL:
1. Stop OpManager service.
2. Open a command prompt in Administrator mode and execute the backup script like shown below:
C:\...\OpManager\bin\backup> BackupDB.bat -targetdb pgsql
3. The backup file will be created under \OpManager\backup folder. The file name would be like Backup_Mysql_to_Pgsql_Oct07_181226_11600.zip. Copy this file into a different location, as we will be uninstalling this instance.
4. Also, copy & save the following files found under \OpManager\classes folder:
5. Download the appropriate OpManager installation file (32 bit or 64 bit) from this link
and install it. While installing, choose PgSQL as the database. This process will uninstall the MySQL installation.
6. Once installed successfully, start the product. This will create the OpManager database in PgSQL. Login to the product to confirm the DB creation is successful.
7. Stop OpManager service.
8. Open a command prompt in Administrator mode and execute the restore script with arguments below:
C:\...\OpManager\bin\backup> RestoreDB.bat "Complete path of the PgSQL compatible backup file"
C:\...\OpManager\bin\backup> RestoreDB.bat "D:\...\Backup\Backup_Mysql_to_Pgsql_Oct07_181226_11600.zip"
9. Once the restore is complete, paste the files copied in Step 4 into the same location, replacing the original files and start OpManager service.
The product will now use PgSQL as its database. You can verify this from the 'Installation & JVM info' column in OpManager UI --> Support --> Support page.