How can I know if Azure Postgres Flexible Server is backed up and receiving maintenance updates if I stop it regularly?

Question

I have an Azure Database for PostgreSQL flexible server in development environment where I schedule it to turn on only weekdays, work hours only.

How can I be sure that it is regularly backed up (for PITR at anytime, if needed) and also receiving maintenance updates from Azure?

It would be great if anyone can share the mechanism behind this. Would it immediately check for updates as soon as it is turned on the next day or so? If that is the case, how will it install updates if I choose maintenance window to be Sunday but it runs only on weekdays?

Thanks.

Answer 1

Hi, @Pitawat Thanks for posting your query in the Microsoft forum.
As we understand the ask here is to understand when the updates are going perform, Please do let me know if that is not accurate.
Maintenance will continue to happen for stopped servers no matter whether they are in a stopped state or in a running state. it is managed service so we take care of this.

Please let me know if you have any additional questions.

Regards
Geetha

Answer 2

Hi PitawatNantamanop-3754,
As far as I know, information about database backup and receiving maintenance updates are as follows.

<Database Backup>
There is no way when database backup begins and ends because Azure Database for PostgreSQL is managed service. If you'd like to know about it, you need to ask Microsoft. Accordng to the KB, backup frequency is once-daily.

concepts-backup-restore

<Receiving maintenance updates>
You may receive maintenance update at Azure monitor's service health. Microsoft may sends it at least s five days before running any maintenance.

service-health-overview
concepts-maintenance

I hope this would help you.

Best regards,
Zaamasu