Difference between revisions of "Archiving Old Data"

From Observer GigaFlow Support | VIAVI Solutions Inc.
Jump to: navigation, search
(Created page with "Category:DatabaseCategory:Technical Notes == Archiving Old Data == After making changes to the GigaFlow server’s configuration, it’s important to make a backup of...")
 
Line 1: Line 1:
 
[[Category:Database]][[Category:Technical Notes]]
 
[[Category:Database]][[Category:Technical Notes]]
== Archiving Old Data ==
 
 
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 <code>C:\Program Files\PostgreSQL\X.X\bin</code>, where X.X is the PostgreSQL revision, e.g 9.5.
 
# Run: <br /><code>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=GigaFlowConfigBackup.sql</code>
 
# You may be prompted for the database password, i.e. <strong>myipfix</strong>. This will create the file GigaFlowConfigBackup.sql in the active directory. Move this to wherever you archive configurations.
 
 
== Restoring From a GigaFlow Configuration Backup ==
 

Revision as of 11:45, 29 July 2019