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.
User-added image
 
  1. 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.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us