SUMMARY
Remove a pending vaulting job from vaulting queue
ISSUE
Purpose
Remove a vaulting job from the vaulting queue.
Description
These steps allow the removal of a vaulting job from the vaulting queue.
Cause
A vaulting job was previously queued and is no longer needed for offsite vaulting. This may be required if a client was previously configured for vaulting and the vaulting option for this client is disabled before all vaulting jobs complete.
Resolution
psql -U postgres bpdb -c update bp.backups set sync_status ='0' where backup_no = 'xxxxx'
Example:psql -U postgres bpdb -c update bp.backups set sync_status ='0' where backup_no = '33085'