Moving Firewall Analyzer's database/ index to different directory in the same server
How to move PostgreSQL data to another drive in the same physical machine?
Follow the steps given below to move the database to a different drive:
- Stop the Firewall Analyzer server/service, if it is running.
- Check the task manager for the process java.exe and postgres.exe, kill the process if any of these process is running.
- Copy the folder <Firewall Analyzer Home>\pgsql to a folder in another drive (e.g., D:\Firewall\pgsql).i.e., the new location to which you want to move the data of PostgreSQL database.
- Rename the present data folder under pgsql folder as dataold and you can delete it later.
- Open the setCommonEnv.bat/sh file, located under <Firewall Analyzer Home>\bin directory.
For Windows:
Edit the following set database home line:
set DB_HOME=%SERVER_HOME%\pgsql
as
set DB_HOME=D:\Firewall\pgsql
where, the D:\Firewall\pgsql is the new location for the PostgreSQL database.
For Linux:
Edit the following set database home line:
DB_HOME=$SERVER_HOME/pgsql
as
DB_HOME=<absolute path of desired location>/pgsql
where, the <absolute path of desired location>/pgsql is the new location for the PostgreSQL database.
 |
The above line may slightly differ for various builds, however, ensure that,
in Windows "set DB_HOME=%SERVER_HOME%\pgsql" is changed to "set DB_HOME=<new drive with absolute path>\pgsql"
or
in Linux the line is changed to "DB_HOME=<absolute path of desired location>/pgsql".
|
- Save the file.
- Start the Firewall Analyzer server/service.
- Check whether the data is correct and the D:\Firewall\pgsql directory size is getting increased.
How to move MSSQL data to another drive in the same physical machine?
- Stop the Firewall Analyzer Server/Service.
- Login to SQL Server database with system administrator permissions.
- Find the current location of the data file and log file for the database firewall by using the following commands:
use firewall
go
sp_helpfile
go
- Detach the database by using the following commands:
use master
go
sp_detach_db 'firewall'
go
- Copy the data file and log file from the current location (<MSSQL Home>\data\firewall.mdf and <MSSQL Home>\data\firewall_log.LDF)
to the new location (<New location>\firewall.mdf and <New Location>\firewall_log.LDF).
- Re-attach the database and point to the new location by using the following commands:
use master
go
sp_attach_db 'firewall' , '<New Location>\firewall.mdf' , '<New Location>\firewall_log.LDF'
go
- Verify the changed location by using the following commands:
use firewall
go
sp_helpfile
go
- Start the Firewall Analyzer Server/Service.
How to move the Firewall Analyzer's Indexes to a different drive/directory on the same server
- Go to Archive Settings page.
- Enable Change Raw Logs Indexing Location check box.
- Modify the Log Indexing Location to the new location and save.
- Move all the directories from previous location to the new location.
Copyright © 2012,
ZOHO Corp. All Rights Reserved.
ManageEngine