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
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 ...Migration step for NetFlow Analyzer from the build 9860 and above with Mysql database (Windows)
Please follow the below steps again to migrate NetFlow Analyzer build 9860 from 32 bit to 64 bit and check on the issue: STEPS: 1. Shut down NetFlow Analyzer service. 2. Backup the below directories \ files to a safe location. Note that these are 2 ...