Backup

Backup of this Wagtail site goes from the production server (synapse, running Ubuntu 20) to my local mac (dendrite), which also runs the development server (sidev) on Ubuntu 22, under VMWare Fusion. Backup is done by a shell script on dendrite, called myserversrsync.sh that ssh's to the wagtail source tree on synapse, called sigwag, and does the following:

• Calls a script on synapse, sigwag/backup/pgbackup.sh, that runs pg_dump on the database, writing the dump to pgbackup.sql in the same directory: sigwag/backup/pgbackup.sql.
• rsync all files in sigwag, including the the database sql dump, to a backup directory on dendrite, called serverbackups.
• All these files are in turn backed up to external disk via Time Machine.

(myserversrsync.sh similarly backs up any other servers I have running).

Restore can be done by copying the backed up files from the serverbackups directory on dendrite to the appropriate location on synapse, cd'ing to sigwag/backups, and running

psql -U <sig user> sig < pgbackup.sql

This project is also saved in git and GitHub, so changes in code on sidev can by synced to the the production code on synapse. A complication is that currently synapse runs Ubuntu 20, whereas sidev runs Ubuntu 22, so the production code is kept in a separate git branch. I haven't wanted to update synapse yet because it runs all the other services of the sig website, so I need to make sure they all work under newer versions of Ubuntu.