Update backup status

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

1. Run a backup history report to identify the backup number or id.

2. 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.