Difference between revisions of "Backup and Restore a GigaFlow Configuration"
From Observer GigaFlow Support | VIAVI Solutions Inc.
Kevin Wilkie (Talk | contribs) (Created page with "The following commands will create a db dump of the flowsec configuration. The only thing you should be prompted for is the 'myipfix' password. This will then create the file ...") |
Kevin Wilkie (Talk | contribs) |
||
Line 4: | Line 4: | ||
When restoring (this will drop the existing database on the server!!), stpo the flowsec service, use the flowsecdump.sql file, upload to new machine and execute the following (supply the 'myipfix' password when prompted) | When restoring (this will drop the existing database on the server!!), stpo the flowsec service, use the flowsecdump.sql file, upload to new machine and execute the following (supply the 'myipfix' password when prompted) | ||
− | psql --host 127.0.0.1 --username=myipfix < ./flowsecdump.sql | + | 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')" | + | psql --host 127.0.0.1 --username=myipfix -c "delete from serverparams where key in('serverid','installtime','license')" |
now restart flowsec. | now restart flowsec. |
Revision as of 09:07, 4 September 2018
The following commands will create a db dump of the flowsec configuration. The only thing you should be prompted for is the 'myipfix' password. This will then create the file flowsecdump.sql in your current folder.
pg_dump --host 127.0.0.1 --username=myipfix --exclude-table="macaddressvendors" --exclude-table="userevent*" --exclude-table="systemhealt*" --exclude-table="savedreportdata" --exclude-table="netflow*" --exclude-table="arp*" --exclude-table="cam*" --exclude-table="searchip*" --exclude-table="all*" --exclude-table="events*" --exclude-table="all*" --exclude-table="profilingstats*" --exclude-table="summary*" --dbname=myipfix --clean --create --file=flowsecdump.sql
When restoring (this will drop the existing database on the server!!), stpo the flowsec service, use the flowsecdump.sql file, upload to new machine and execute the following (supply the 'myipfix' password when prompted)
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')"
now restart flowsec.