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. The database restore script is located in the tools directory within BCAN_DATA.

To restore the embedded PostgreSQL database

1. Stop the BCA-Networks web server:
   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.

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. 

   Note

   The database backup file is assumed to be located in the BCAN_DATA\dbbackup or BCAN_DATA/dbbackup directory.

3. Restart the BCA-Networks web server.
   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.