What are the possibilities to restore deleted Postgresql Flexible Server?

Question

Hello,

I am analysing the possible ways of how to restore Azure Database for Postgresql - Flexible Server that was accidentally deleted. According to Azure documentation, the only way is to create a support ticket which might be successful but doesn't have to be. I also noticed that for Azure Database for MySql - Flexible Server, it is possible to use Azure API to restore such a deleted server.

Do you plan to introduce a similar solution for Postgresql Flexible Server?

What are the rules for a successful restore process of a deleted server for Postgresql - Flexible Server in cases when a support ticket is raised?

By the way, I know that a delete lock should be used to prevent accidental deletion.

Best regards

Answer 1

Salamon, Tomasz Thank you for reaching out.

My understanding is that you are trying to restore an accidently deleted server on Azure PostgreSQL Flexible Server.

It's possible, but it will depend on the backup retention in the backend please keep in mind that this is past 5 days then it is not supported. The only way to do restore will be at the back end by creating a support ticket as you have mentioned above. Please let me know if you don't have a support plan. We can offer you a free one-time support ticket.

I also noticed that for Azure Database for MySQL - Flexible Server, it is possible to use Azure API to restore such a deleted server. Do you plan to introduce a similar solution for PostgreSQL Flexible Server?

Yes. I have checked internally and that is on the way and will be available very soon.

It will be also announced here when available or in preview.

What are the rules for a successful restore process of a deleted server for PostgreSQL - Flexible Server in cases when a support ticket is raised?

You can work with CSS by providing your server's name, which was accidently deleted, and they will restore it at the back end for you.

I hope this answers your question.

Please let me know if you have additional questions.

Regards,

Oury

Answer 2

@Oury Ba-MSFT Hello Oury! Today we had the same issue. The database is gone and I cannot manage to find the restoration by using the latest API "2023-03-01-preview" from this documentation https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/release-notes-api. Do you know if there is any known solution yet? Having this on production with IAC as today's most recent project work, is extremely risky. The backups are useless in this case as it drops in cascade with the server.

KR,