Firewall Analyzer Mysql to Pgsql migration steps.

Firewall Analyzer Mysql to Pgsql migration steps.

  1. Stop the Firewall Analyzer Service.
  2. Take the backup or a VM snapshot of ManageEngine\Firewall folder.
  3. 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:

MysqlToPgsqlRestore.bat
MysqlToPgsqlBackup.bat

3. lib:

FwaPgsqlMigration.jar
postgresql_jdbc4.jar (overwrite if exists)

Steps to Backup:
  1. Open the command prompt as an administrator.
  2. Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlBackup.bat.
  3. 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:
  1. Execute changeDBServer.bat to change Database from MySQL to PgSQL.
  2. Now navigate to ManageEngine\Firewall\bin and execute initPgsql.bat wait till the process completes.
  3. Start the Firewall Analyzer Service and check product is up & running.
  4. If yes,
  5. Stop the Firewall Analyzer service.
  6. Open the command prompt as an administrator.
  7. Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlRestore.bat, browse and select the created backup file.
  8. Now click on 'OK' and wait till the database is completely restored.
  9. Once done, Start the Firewall Analyzer service and check everything is working as expected.

Linux:

  1. Stop the Firewall Analyzer Service.
  2. Take the backup or a VM snapshot of ManageEngine\Firewall folder.
  3. 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:

MysqlToPgsqlRestore.bat
MysqlToPgsqlBackup.bat

3. lib:

FwaPgsqlMigration.jar
postgresql_jdbc4.jar (overwrite if exists)

Steps to Backup:
  1. Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlBackup.sh
  2. 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:
  1. Execute changeDBServer.sh to change Database from MySQL to PgSQL.
  2. Now navigate to ManageEngine\Firewall\bin and execute initPgsql.sh wait till the process completes.
  3. Start the Firewall Analyzer Service and check product is up & running.
  4. If yes,
  5. Stop the Firewall Analyzer service.
  6. Navigate to ManageEngine\Firewall\tool and execute MysqlToPgsqlRestore.sh, browse and select the created backup file.
  7. Now click on 'OK' and wait till the database is completely restored.
  8. Once done, Start the Firewall Analyzer service and check everything is working as expected.