Backing up the embedded PostgreSQL database

This topic describes how to back up the embedded PostgreSQL database by using the database backup script.

You can back up the database while the product is running. We recommend scheduling the backup during non-peak times. You also might want to store the backup files on a remote disk. Also, you can use the Windows or Linux scheduler to schedule regular backups of the product database.

Do the following:

1. On the application server, navigate to the BCAN_HOME\tools directory.

2. Use the following command to back up the application database:

   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.The backup file is written to the BCAN_DATA\dbbackup directory. 

After you back up

After you have backed up the database, do the following:

1. Navigate to the BCAN_DATA directory and make a copy of the keystore.bcfks file.
2. Note down the password for the keystore.bcfks file:
   • (Windows) Open the Registry, and navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Apache Software Foundation\Procrun 2.0\enatomcat\Parameters\Java. Double-click Options in the right pane. The
     -Djavax.net.ssl.keyStorePassword property contains the password.
   • (Linux) Navigate to the /etc/systemd/system directory and open the enatomcat.service file. The -Djavax.net.ssl.keyStorePassword property contains the password.
3. Move the copy of keystore.bcfks and bcan.dump to a secure location. These files and password will be required for the database restore process.