i dropped Azure Cosmos DB for PostgreSQL Cluster resource

Question

i dropped Azure Cosmos DB for PostgreSQL Cluster resource

Jakub Ryška 20

Hello,

by mistake, I dropped Azure Cosmos DB for PostgreSQL Cluster resource.

Can I recover this resource to state before dropping with it's data?

Thanks

Mallaiah Sangi 560 Reputation points Microsoft External Staff

2025-04-15T15:05:58.68+00:00

Hi Jakub RyškaThanks for posting your question in the Microsoft Q&A forum.

Restoring a dropped Azure Database for PostgreSQL flexible server instance is possible within five days of deletion, as backups are retained during this period. Here’s a brief overview of the process:

Locate the Backup: Use the Azure portal's Activity Log to find the deletion event and retrieve the resourceId and submissionTimestamp attributes from the JSON output.

Use REST API: Navigate to the Azure Database for PostgreSQL flexible server Create Server REST API page. Provide the necessary details, including the resourceId, submissionTimestamp, and the location of the dropped server.

Restore Settings: Configure the restore settings, such as pointInTimeUTC (submission timestamp + 10 minutes), and set the createMode to ReviveDropped

Please refer to the official Microsoft documentation to restore the deleted databases.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restore-dropped-server?wt.mc_id=knowledgesearch_inproduct_9ccfc0ae-fdbf-4e6d-99fc-db7dd8a70d95#steps-to-restore

I hope this information helps. Please do let us know if you have any further queries.

Accepted answer

0 additional answers

Your answer

Mallaiah Sangi 560 Reputation points Microsoft External Staff

2025-04-15T15:05:58.68+00:00

Hi Jakub RyškaThanks for posting your question in the Microsoft Q&A forum.

Restoring a dropped Azure Database for PostgreSQL flexible server instance is possible within five days of deletion, as backups are retained during this period. Here’s a brief overview of the process:

Locate the Backup: Use the Azure portal's Activity Log to find the deletion event and retrieve the resourceId and submissionTimestamp attributes from the JSON output.

Use REST API: Navigate to the Azure Database for PostgreSQL flexible server Create Server REST API page. Provide the necessary details, including the resourceId, submissionTimestamp, and the location of the dropped server.

Restore Settings: Configure the restore settings, such as pointInTimeUTC (submission timestamp + 10 minutes), and set the createMode to ReviveDropped

Please refer to the official Microsoft documentation to restore the deleted databases.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restore-dropped-server?wt.mc_id=knowledgesearch_inproduct_9ccfc0ae-fdbf-4e6d-99fc-db7dd8a70d95#steps-to-restore

I hope this information helps. Please do let us know if you have any further queries.

Answer 1

Hi @Jakub Ryška ,

if you deleted the Azure Cosmos DB for PostgreSQL Cluster resource there is no option to restore.

Please take a look here:

https://learn.microsoft.com/en-us/azure/cosmos-db/postgresql/concepts-backup#restore

Important

Deleted clusters can't be restored. If you delete the cluster, all nodes that belong to the cluster are deleted and can't be recovered. To protect cluster resources, post deployment, from accidental deletion or unexpected changes, administrators can leverage management locks.

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards

Andreas Baumgarten

Share via

i dropped Azure Cosmos DB for PostgreSQL Cluster resource

0 additional answers

Your answer