My azure PostgresDb just got deleted by itself and no logs are there

Shailendra Singh 0

I have my postgres db on azure , in which i have all my databases , so it just got deleted by itself and no logs are shown anywhere.

Shailendra Singh 0 Reputation points

2025-09-09T04:42:09.8566667+00:00

yes , I did Restore the db , but is there any way to check the logs ?

1 answer

Saraswathi Devadula 13,315 Reputation points Microsoft External Staff Moderator

2025-09-09T04:40:34.6933333+00:00
Hello Shailendra Singh
When a server is deleted, database server backups may be retained within the service for up to 5 days.

We ask that you follow the following documents to restore your server, https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-restore-dropped-server

pgaudit extension provides detailed audit logging which is not enabled by default.

Server logs capture (PostgreSQL standard logs) must be enabled explicitly to access logs for troubleshooting, monitoring, and audit-level details.

Azure monitoring and PostgreSQL logging features are available independently of pgaudit but require server logs capture and diagnostic settings to be enabled.

Thus, without enabling pgaudit and server logs capture, you cannot find the logs to check the server deletion details.

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/security-audit?tabs=portal
Please sign in to rate this answer.

1 person found this answer helpful.
Saraswathi Devadula 13,315 Reputation points Microsoft External Staff Moderator

2025-09-10T06:06:11.9466667+00:00

Hello Shailendra Singh
Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer