Planned Maintenance Notification: Temporary Downtime for Azure PostgreSQL Flexible Server on 23rd March 2025 (IST)

Question

We have received a notification about a planned maintenance window for our Azure Database for PostgreSQL Flexible Server on 23rd March 2025 (IST). Could you please confirm if there is any risk of data loss during this maintenance? Additionally, should we take a manual backup of our database beforehand, or will the automated backups be sufficient to ensure data integrity? Are there any recommended post-maintenance validation or monitoring steps to confirm that the server is performing optimally and remains stable after the maintenance?

Answer 1

Hello Sudhakar P

Greetings!

I understood that you want to know about the planned maintenance for your Azure Database for PostgreSQL Flexible Server on 23rd March 2025.

Please be informed that there is no risk of data loss during the planned maintenance for Azure Database for PostgreSQL Flexible Server. Azure Database for PostgreSQL - Flexible Server supports both zone-redundant and zonal models for high availability configurations. Both high availability configurations enable automatic failover capability with zero data loss during both planned and unplanned events.

Please refer the below document for better understanding,
https://learn.microsoft.com/en-us/azure/reliability/reliability-postgresql-flexible-server#availability-zone-support

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-maintenance

Regarding the backup, Azure Database for PostgreSQL Flexible Server automatically performs regular backups of your server. Automated backups should be sufficient to ensure data integrity.
Please refer the below document for better understanding,
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-backup-restore

To ensure optimal performance and stability of your Azure Database for PostgreSQL Flexible Server post-maintenance, consider monitoring key metrics such as CPU usage, memory consumption, and query performance.

Kindly please refer the below queries, which will help to check the metrics.
https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/how-to-monitor-high-availability

https://learn.microsoft.com/en-us/azure/postgresql/flexible-server/concepts-monitoring

I hope this has been helpful!

Your feedback is important so please take a moment to accept answers. If you still have questions, please let us know what is needed in the comments so the question can be answered. Thank you for helping to improve Microsoft Q&A!

If this answers your query, do click Accept Answer and Upvote for was this answer helpful.

Thank you.