Task #2775
closed
Configure backuppc to run the local DB backup scripts and write the backup status on the remote host
100%
Description
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 log can be also used by nagios to verify that the remote backup is running correctly.
Related issues
Updated by Andrea Dell'Amico over 9 years ago
- Related to Task #2774: Configure the mysql and postgresql local backups to not run if the remote backup is active added
Updated by Andrea Dell'Amico over 9 years ago
- Related to deleted (Task #2774: Configure the mysql and postgresql local backups to not run if the remote backup is active)
Updated by Andrea Dell'Amico over 9 years ago
- Blocks Task #2774: Configure the mysql and postgresql local backups to not run if the remote backup is active added
Updated by Andrea Dell'Amico over 9 years ago
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.
Updated by Andrea Dell'Amico almost 9 years ago
The postgresql backup script is: /usr/local/sbin/postgresql-backup
Updated by Tommaso Piccioli almost 9 years ago
- Status changed from New to In Progress
- % Done changed from 0 to 100
Updated by Tommaso Piccioli almost 9 years ago
- Status changed from In Progress to Feedback
Please check if it works tomorrow.
Updated by Andrea Dell'Amico almost 9 years ago
- Status changed from Feedback to Closed
It's working correctly.
