How to clear stale jobs in UB

SUMMARY

How to clear hung backup jobs

ISSUE

How to clear stale jobs which show active (hour glass) but are no longer warning.

RESOLUTION

 

*** Caution:  For advanced users only. ***

*** May cause un-repairable damage! ***



Run this command to update a hung or stale backup job which is showing as active however is not progressing.  This command will update the backup status to show the backup as failed.  

Example using backup number 54739
psql -U postgres bpdb -c "update bp.backups set status=21568 where backup_no=54738"


 

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