PGSQL 32bit to 64 bit server to server migration (Postrgesql DB) for NetFlow Analyzer

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 different server with PGSQL DB :

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. Follow the below steps on both the old and the new server -
1) Stop the DB by executing stopDB.bat under NetFlow_Home/bin directory.
2) Navigate to NetFlow_Home/pgsql/data directory.
3) open postgresql.conf file and replace the entry #listen_addresses = 'localhost' with  listen_addresses = '*'
                 by default it will be in form of #listen_addresses = 'localhost'. Just make it  listen_addresses = '*'.

4) open pg_hba.conf file and search for the entry under # IPv4 local connections:
                  add new entry here  host    all             all             all                     trust 

5) Shutdown the DB using stopDB.bat [if still running] and start the DB again using startDB.bat under NetFlow_Home/bin directory.

6. Start the database on both the servers using command prompt by navigating to <NetFlow\bin> and execute startdb.bat respectively.










7. 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

8. 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)

9. 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.

10. Stop database on both the servers by executing the stopDB.bat/sh under <NetFlow_Home>/bin

11. Now start the new installation service and check is everything working fine.


Follow the steps below to Move NetFlow Analyzer to a New drive/volume 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.


Note - You can move 32 bit or 64 bit installation in the same manner, make sure you are installing the same build/bit of Netflow Analyzer.

          • 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 ...
          • 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) ...
          • NetFlow PGSQL drive migration.

            Hi, Please follow the steps below to migrate the installation to a different drive. Note: A.) The build number of the NetFlow Analyzer should be the same on both the servers. (You can find the Build number by clicking on the 'About' link on the top ...
          • Migration step to migrate NetFlow Analyzer from build 9860 and above with MySQL DB (Linux)

            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 ...
          • NetFlow Analyzer DB folder Migration after 12.5 and above

            Please follow the below steps to migrate Postgres DB folder alone from one setup to another: Note: The steps can be followed between 2 installation of same version of application In Old Install: 1. Stop the OpManager Service from the Services ...