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"