Migration Database to PGSQL in v10

Database Migration from Mysql to Postgres in NetFlow Analyzer version 10250

Steps to Migrate NetFlow Standalone Mysql DB to pgsql Datase

Note: Migration is applicable only in build 10250
Both the MYSQL and PGSQL installation should be in the same server to perform the Migration.
Make sure that you have enough disk space available in the drive for the complete data migration.

Note: Shutdown Netflow Analyser service and take a back up of the "Netflow" folder before starting the data migration.

 1. Shutdown Netflow Analyzer service of the current installation.

 2. Open a CMD prompt as administrator and Navigate to <NetFlow>\bin, Execute na_service -r ( Step only for Windows )

3. In cmd prompt Navigate to <NetFlow>\troubleshooting and execute rawcleanup.bat ( Windows ) \ rawcleanup.sh ( Linux ). Wait for it to complete.
            
4. Rename Current NetFlow installation directory <Netflow> to <NetFlow_old>

  Note: Free space available in the drive should be greater than the size of the NetFlow folder. If not move the old installation folder to a different drive (in the same server). 

 5. Install New NetFlow Analyzer Installer 10250(Pgsql). Download link:  http://archives.manageengine.com/netflow/10250/ 

 6. Start New NetFlow analyzer, Connect to the UI and apply for License. (License file can be obtained from old Mysql Installer location, NetFlow_Home/lib/AdventNetLicense.xml)

To Start application in Linux : Navigate to NetFlow_Home/bin and execute ./run.sh.

 7. Tune the product as mentioned in the below link. 


8. Download and unzip  MigrateData.zip

It contains a folder named MigrateData. Copy the MigrateData folder to the new Postgres install under NetFlow directory.(Ex: C:\ManageEninge\Netflow)


Stop the NetFlow Analyzer service.

 9. In Command Prompt Navigate to <NetFlow_Home>\MigrateData folder Execute "migrate.sh/.bat". 
(Ex: C:\ManageEninge\Netflow\MigrateData)
  • Provide the path of old NetFlow folder ( For eg. C:/ManageEngine/NetFlow_old/ ) and press Enter
  • Wait for script to complete and it will prompt to start the NetFlow Analyzer service

 10. Start the NetFlow Analyzer serviceYou can check the current migration status in the API Client Setting Tab.