Backups - nsc-norway/system GitHub Wiki

The LIMS servers on the UiO network are backed up by the central UiO system.

• cees-lims.sequencing.uio.no
• sandbox-lims.sequencing.uio.no

File-based backup

Filesystem backups are coordinated with [email protected].

All of /opt/gls/clarity is added to the backup.

To confirm that something is backed up, run this command:

sudo dsmc q backup -subdir=yes /opt/gls/clarity/

(can also remove -subdir=yes to not show the entire tree)

Database backup

Direct backup of the directory /var/lib/pgsql is disabled. These will be inconsistent anyway, because the backup tool doesn't take all files at exactly the same time.

To take backups, we use an SQL dump. The setup procedure is described in backup/set-up-database-backup.sh in this repo. We create a cron job which runs a script every night to dump the SQL. The script is installed in /usr/local/bin/sql-dump.sh . The script itself should be run as the postgres user (database superuser), and will dump all SQL data into /var/local/backup using the pg_dumpall command.

If there is a problem we will get an email from cron, but only if the root email is set up correctly (see: Setup ).