Firewall Analyzer Mysql to Pgsql migration steps.
- Stop the Firewall Analyzer Service.
- Take the backup or a VM snapshot of ManageEngine\Firewall folder.
- Download the correct zip files based on your OS(32/64bit) from the below link and extract it under <Firewall Analyzer Home>.
The following files and folder will be extracted under Firewall_Home directory:
1. pgsql folder
2. tools:
2. tools:
MysqlToPgsqlRestore.bat
MysqlToPgsqlBackup.bat
3. lib:
FwaPgsqlMigration.jar
postgresql_jdbc4.jar (overwrite if exists)
Steps to Backup:
- Open the command prompt as an administrator.
- Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlBackup.bat.
- Once the backup is completed successfully, the backup file will be stored under <Firewall Analyzer Home>backup directory with the file name like 'backup_firewall_<Build_Number>_MM_DD_YYYY_hh_mm.data'.
Steps to Restore:
- Execute changeDBServer.bat to change Database from MySQL to PgSQL.
- Now navigate to ManageEngine\Firewall\bin and execute initPgsql.bat wait till the process completes.
- Start the Firewall Analyzer Service and check product is up & running.
- If yes,
- Stop the Firewall Analyzer service.
- Open the command prompt as an administrator.
- Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlRestore.bat, browse and select the created backup file.
- Now click on 'OK' and wait till the database is completely restored.
- Once done, Start the Firewall Analyzer service and check everything is working as expected.
Linux:
- Stop the Firewall Analyzer Service.
- Take the backup or a VM snapshot of ManageEngine\Firewall folder.
- Download the correct zip files based on your OS(32/64bit) from the below link and extract it under <Firewall Analyzer Home>.
The following files and folder will be extracted under Firewall_Home directory:
1. pgsql folder
2. tools:
2. tools:
MysqlToPgsqlRestore.bat
MysqlToPgsqlBackup.bat
3. lib:
FwaPgsqlMigration.jar
postgresql_jdbc4.jar (overwrite if exists)
Steps to Backup:
- Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlBackup.sh
- Once the backup is completed successfully, the backup file will be stored under <Firewall Analyzer Home>backup directory with the file name like 'backup_firewall_<Build_Number>_MM_DD_YYYY_hh_mm.data'.
Steps to Restore:
- Execute changeDBServer.sh to change Database from MySQL to PgSQL.
- Now navigate to ManageEngine\Firewall\bin and execute initPgsql.sh wait till the process completes.
- Start the Firewall Analyzer Service and check product is up & running.
- If yes,
- Stop the Firewall Analyzer service.
- Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlRestore.sh, browse and select the created backup file.
- Now click on 'OK' and wait till the database is completely restored.
- Once done, Start the Firewall Analyzer service and check everything is working as expected.
New to ADSelfService Plus?
Related Articles
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 ...Migration of Database from MYSQL to MSSQL in the Firewall Analyzer
Please refer the below link for MYSQL to MSSQL migration. http://www.manageengine.co.in/products/firewall/help/appendix/migrating-data-mysql-mssql-database.html Note: I request to stop the Firewall Analyzer service and take the backup of complete ...Device Expert 5990 migration from Mysql to Pgsql
Please follow the steps to migrate DeviceExpert data from mysql to postgres. Note: .bat is for Windows and .sh is for linux installation. DeviceExpert Backup steps : Please stop DeviceExpert. IMPORTANT: Take a copy of the entire <DeviceExpert> ...Netflow Analyzer migration (Links based on installation type)
Kindly refer the links below to migrate your Netflow Analyzer installation per your need - https://support.zoho.com/portal/manageengine/helpcenter/articles/mysql-32-bit-installation-to-64-bit-migration (For builds up to 9700) ...PGSQL 32bit to 64 bit server to server migration (Postrgesql DB) for NetFlow Analyzer
NetFlow Analyzer installation can be migrated to a different server with old database and configuration provided both the installation are in same version and build number. Please follow the steps given below to migrate Netflow Analyzer to a ...