3.4.7.8. Database Backup

Manual Database Backup

1. Log in to the Strawberry Admin panel
2. Click on the “Misc” tab
3. Click on the “Database Backup” bar to expand it
4. Click on the “Backup Now” button to create an instant backup of the Strawberry database

Automatic Database Backup

Strawberry can create backups of its PostgreSQL database regularly. A database backup is created at 3 am (server time) every morning by default. The default backup location is /opt/sb4/data/backups/ on the Strawberry server.

Changing the Database Backup Settings

If you wish to change the database backup location or frequency, do the following.

1. Navigate to the Strawberry config file directory

 cd /opt/sb4/app/fsbase/config

2. Copy the file “database-backup.yml.example” to “database-backup.yml”

cp database-backup.yml.example database-backup.yml

3. Edit the file “database-backup.yml” using an editor of your choice but make sure not to change the formatting or indentation

nano database-backup.yml

You will now see the file’s content with the default database backup settings

---
production:
  backup_path: "/opt/sb4/app/backups"
  delete_after_days: 14
  recurrence: daily
# Optional
#  --- {}#
#

• “backup_path” is the location in which the backup is stored
• “delete_after_days” is a numeric value that determines after how many days database backups will be removed from the backup location. Strawberry will only delete backups older than the numeric value defined here
• “recurrence” determines how often database backups are created. Daily backups are highly recommended!

4. Save your changes and exit the editor
5. Restart the Strawberry service using “sb restart.” If Strawberry is configured to run on a High Availability cluster, then use the respective restart command.