Postgress Database Migration 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 between PGSQL between different server :
NOTE: Make sure that the raw data are dropped using rawCleanup.bat/sh under <NetFlow\troubleshooting> to speed up the migration
1. Stop the NetFlow analyzer service on the old server and make sure postgres and java are not running.
2. Install application of same build in new server, Start and stop the service once. You can download the same version and build number by browsing the below given link:
http://archives.manageengine.com/netflow/
3. Open command prompt as Administrator in New Server and navigate to the installation directory (NetFlow_Home\bin).
4. Execute "reinitialize.bat/sh".
5. Start the database on both the servers using command prompt by navigating to <NetFlow\bin> and execute startdb.bat/sh respectively.
6. In a new command prompt on the old server navigate to <NetFlow\pgsql\bin> and execute
pg_dump -U postgres -h <Old server IP Address> -p 13310 netflow | psql -U postgres -h <new server IP Address> -p 13310 netflow
Example:
pg_dump -U postgres -h 192.168.1.1 -p 13310 netflow | psql -U postgres -h 192.168.1.2 -p 13310 netflow
7. Please make sure that there is no communication issue between old and new server and also no error should throw in between migration. (It may take few minutes or hours based on the data)
8. Once the dump is completed . Copy the data and tmp folder from the old server Netflow_Home directory to the new server Netflow_Home directory.
9. Stop database on both the servers by executing the stopDB.bat/sh under <NetFlow_Home>/bin
10. Now start the new installation service and check is everything working fine.
Follow the below steps to Migrate NetFlow Analyzer to a New drive on the same server from 32 to 64bit:
NOTE: Make sure that the raw data are dropped using rawCleanup.bat/sh under <NetFlow\troubleshooting> to speed up the migration
1. Stop the NetFlow analyzer 32 bit service . Make sure postgres and java are not running.
2. Rename the 32bit installation NetFlow folder to NetFlow_old.
3. In the 32bit installation navigate to <old_NetFlow>\conf\database_params.conf change the port (find and replace all) from 13310 to 13309.
4. Install 64bit application of same build, start and stop the service and execute reinitializeDB.bat from the loaction NetFlow_Home/bin (64 bit installation port by default will be 13310)
5. Start the database for both the installation in separate cmd prompt from the location <NetFlow\bin> by executing startdb.bat 13310/13309 for 64bit and 32 bit respectively.
6. In a new cmd prompt navigate to 32bit install <old_NetFlow\pgsql\bin> and execute
pg_dump -U postgres -h 127.0.0.1 -p 13309 netflow | psql -U postgres -h 127.0.0.1 -p 13310 netflow
7. Once the dump is completed . Copy the data and tmp folder from 32 bit installation folder to the 64 bit installation folder.
In case you have any question, please feel free to put a post here or send a mail to netflow-support@manageengine.com.
Thanks & Regards,
Aravind Lenin
Technical Support Engg- Netflow Analyzer
Please follow the steps given below to migrate between PGSQL between different server :
NOTE: Make sure that the raw data are dropped using rawCleanup.bat/sh under <NetFlow\troubleshooting> to speed up the migration
1. Stop the NetFlow analyzer service on the old server and make sure postgres and java are not running.
2. Install application of same build in new server, Start and stop the service once. You can download the same version and build number by browsing the below given link:
http://archives.manageengine.com/netflow/
3. Open command prompt as Administrator in New Server and navigate to the installation directory (NetFlow_Home\bin).
4. Execute "reinitialize.bat/sh".
5. Start the database on both the servers using command prompt by navigating to <NetFlow\bin> and execute startdb.bat/sh respectively.
6. In a new command prompt on the old server navigate to <NetFlow\pgsql\bin> and execute
pg_dump -U postgres -h <Old server IP Address> -p 13310 netflow | psql -U postgres -h <new server IP Address> -p 13310 netflow
Example:
pg_dump -U postgres -h 192.168.1.1 -p 13310 netflow | psql -U postgres -h 192.168.1.2 -p 13310 netflow
7. Please make sure that there is no communication issue between old and new server and also no error should throw in between migration. (It may take few minutes or hours based on the data)
8. Once the dump is completed . Copy the data and tmp folder from the old server Netflow_Home directory to the new server Netflow_Home directory.
9. Stop database on both the servers by executing the stopDB.bat/sh under <NetFlow_Home>/bin
10. Now start the new installation service and check is everything working fine.
Follow the below steps to Migrate NetFlow Analyzer to a New drive on the same server from 32 to 64bit:
NOTE: Make sure that the raw data are dropped using rawCleanup.bat/sh under <NetFlow\troubleshooting> to speed up the migration
1. Stop the NetFlow analyzer 32 bit service . Make sure postgres and java are not running.
2. Rename the 32bit installation NetFlow folder to NetFlow_old.
3. In the 32bit installation navigate to <old_NetFlow>\conf\database_params.conf change the port (find and replace all) from 13310 to 13309.
4. Install 64bit application of same build, start and stop the service and execute reinitializeDB.bat from the loaction NetFlow_Home/bin (64 bit installation port by default will be 13310)
5. Start the database for both the installation in separate cmd prompt from the location <NetFlow\bin> by executing startdb.bat 13310/13309 for 64bit and 32 bit respectively.
6. In a new cmd prompt navigate to 32bit install <old_NetFlow\pgsql\bin> and execute
pg_dump -U postgres -h 127.0.0.1 -p 13309 netflow | psql -U postgres -h 127.0.0.1 -p 13310 netflow
7. Once the dump is completed . Copy the data and tmp folder from 32 bit installation folder to the 64 bit installation folder.
In case you have any question, please feel free to put a post here or send a mail to netflow-support@manageengine.com.
Thanks & Regards,
Aravind Lenin
Technical Support Engg- Netflow Analyzer