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 regular backups of its PostgreSQL database. A database backup is created at 3 am (server time) every morning. The default backup location is /opt/sb/data/backups/ on the Strawberry server.

Changing the Database Backup Settings

To change the database backup location or frequency, follow these steps.

1. Navigate to the Strawberry config file directory.

 cd /opt/sb/config/fsbase

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, but do not change the formatting or indentation.

nano database-backup.yml

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

• “backup_path” is the configured location in which the database backup is stored.
• “delete_after_days” determines the retention period of database backups until they are permanently deleted.
• “recurrence” determines the interval in which database backups are created. “daily” is the default setting and the recommended minimum.

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