Restoring the embedded PostgreSQL database

This topic describes how to restore a previously backed-up version of the PostgreSQL database by using the database restore script on the same server. For instructions on restoring the database to a different server, see Migrating-TrueSight-Network-Automation-from-one-server-to-another. 

The database restore script is located in the tools directory within BCAN_HOME. 

To restore the embedded PostgreSQL database

1. Stop the BCA-Networks web server:
   
   

2. Run the Database Restore script.
   
   

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
   This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.
   

   In the command, <filename> is an optional file name (no path, just file). The default value is bcan.dump.
   The restore operation automatically updates the database to the current release of the installed software.

   Important

   • The database backup file is assumed to be located in the BCAN_DATA\dbbackup or BCAN_DATA/dbbackup directory.
   • Make sure that the keystore.jceks file and the original file from the backup server are the same.

3. Restart the BCA-Networks web server.