D4Science Infrastructure

Andrea Dell'Amico wrote:

BackupPC can be globally configured to run mysql/postgresql backups as a pre-step.

When the backuppc operations are finished, a post script will run on the remote host. In the /var/log/backuppc.log file the following information will be written:

BACKUP_TIMESTAMP=<Unix timestamp>
DB_DUMP_RESULT=<OK/FAILED>

The second variable should better be something like

BACKUP_RESULT=<OK/"failure reason, if any">

Because it's related to the whole system backup and not the DB one.

The log can be also used by nagios to verify that the remote backup is running correctly.

The postgresql backup script is: /usr/local/sbin/postgresql-backup