SUMMARY
This article provides the command that allows your to change the backup status.
ISSUE
There are rare occasions when a backup status needs to be changed to failed.
RESOLUTION
- Run a backup history report to identify the backup number or id.
- From a command line, run the following command to change the backup status to a 'failed' status.
psql bpdb -U postgres -c "update bp.backups set status = 21568 where backup_no=43881"
In the example above, we are changing backup 43881 to a failed status.
CAUSE
The backup job does not complete its final update process.