Backup and Restore a GigaFlow Configuration
From Observer GigaFlow Support | VIAVI Solutions Inc.
Revision as of 13:25, 14 January 2020 by Kevin Wilkie (Talk | contribs)
Creating a GigaFlow Configuration Backup For Use On A New Server
After making changes to the GigaFlow server’s configuration, it’s important to make a backup of the configuration.
Using Windows:
- Open a Windows command prompt as administrator.
- Assuming that the PostgreSQL path has been added to windows, you can run the pg_dump command below directly. If not, either add it to the path or change the active directory to
C:\Program Files\PostgreSQL\X.X\bin
, where X.X is the PostgreSQL revision, e.g 9.5. - Run:
"D:\Program Files\PostgreSQL\10\bin\pg_dump.exe" --table=attributecategories --table=attributevalues_0 --table=attributevalues_1 --table=attributevalues_2 --table=attributevalues_3 --table=attributevalues_4 --table=attributevalues_5 --table=attributevalues_6 --table=blacklistslocal --table=blacklistslocalentries --table=blacklistsources --table=customerdevicesettings --table=customersettings --table=dataaccessgroupmembers --table=dataaccessgroups --table=definedapplications --table=deviceinterfaces --table=devices --table=eventtriggers --table=eventtypes --table=flowobjects --table=forensicsreports --table=geoips --table=gigastors --table=integrations --table=interfacetypes --table=gigastores --table=ldapgroups --table=ldapusers --table=multiservertargets --table=networkaudits --table=pentypes --table=penvendors --table=portalusers --table=portparams --table=profilers --table=profilerstoallowedprofiles --table=profilerstoentryprofiles --table=queryfielderservers --table=reportlinks --table=savedreports --table=serverparams --table=serversubnetport --table=serversubnets --table=snmppollerclasses --table=snmppollerclassesforsysoid --table=sqlreports --table=standardapplications --table=stattypes --table=syslogprocessors --table=syslogprocessorsdefault --table=trafficgroups --table=trafficgroupsdeployed --table=eventrunners --table=eventrunners_versioned --table=usergroups --table=userldapsettings --table=userpermissions --table=users --table=whitelist -U myipfix -f c:/temp/backup.sql
- You may be prompted for the database password, i.e. myipfix. This will create the file GigaFlowConfigBackup.sql in the active directory. Move this to wherever you archive configurations.
Restoring From a GigaFlow Configuration Backup
Warning: the following process will drop the existing database on the server.
- Stop the GigaFlow service (GigaFlow.exe).
- Upload the required GigaFlowConfigBackup.sql file to the machine.
- psql --host 127.0.0.1 --username=myipfix -c "drop database myipfix"
- psql --host 127.0.0.1 --username=myipfix -c "create database myipfix owner=myipfix"
- Run:
psql --host 127.0.0.1 --username=myipfix < ./flowsecdump.sql
psql --host 127.0.0.1 --username=myipfix -c "delete from serverparams where key in('serverid','installtime','license')" - You may be prompted for the database password, i.e. myipfix.
- Restart GigaFlow.