Backing Up the Workload Services Management Database

PostgreSQL provides the back-end database for operations in Stratus Cloud Workload Services. When you install Workload Services, the installation script automatically starts the PostgreSQL service in the Stratus virtual appliance and creates a management database. Workload Services populates this database with information about the configuration of your OpenStack environment as well as information about the hypervisors, applications, and instances that you manage with Workload Services.

In most cases, you do not need to manually manage the database or the appliance, and you must not interfere with their operation; however, it is important to set up daily backups of the PostgreSQL database files to another system to ensure that you can recover your Workload Services configuration in the event of a failure.

Workload Services automatically creates incremental backups of the PostgreSQL database on a daily basis and full backups of the database on a weekly basis. These backups are stored in the /opt/stratus/backups/database/stratuscloud directory in the file system of the Stratus appliance. To preserve the database files for recovery, configure your backup server to back up the contents of this directory on a daily basis.

If you ever need to resolve problems with the Stratus appliance or use your database backups to recover the PostgreSQL database, contact your service representative for assistance.