A PostgreSQL flexible server backup to a backup vault is stuck, how do I cancel it?

Question

Since more than 3 days a PostgreSQL flexible server backup to a backup vault is running, normally it takes less than 10 minutres. This also causes new backups to fail, because only one backup can be done at a time. I do not see a way to cancel the backup though, not in UI, nor using the CLI commands of "az dataprotection job": you can just view the status.

Answer 1

@August Admin
Thanks for the question and for using Microsoft Q&A platform.

As per my understanding, it seems like you are experiencing issues with a PostgreSQL flexible server backup running for more than 3 days, causing new backups to fail.

You can try the following steps to resolve the issue:

1. Sometimes, restarting the server can help clear the stuck backup job. You can do this from the Azure portal by navigating to your PostgreSQL flexible server and selecting "Restart" under the "Overview" section.
2. If the backup job is still stuck, you might need to delete the backup instance. You can do this using the portal or Azure CLI.
   https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-delete-backups?tabs=portal-delete-on-demand-backups
   https://learn.microsoft.com/en-us/azure/backup/backup-azure-database-postgresql-flex-manage

You can restart the job if required.

Hope this helps. Please let us know if you have any further questions.