Schedule maintenance in Azure Database for PostgreSQL flexible server

You can specify scheduled maintenance options for each Azure Database for PostgreSQL flexible server in your Azure subscription. Options include the type of scheduled maintenance and notification settings for upcoming and finished maintenance events.

Steps to schedule maintenance

Use the Azure portal:

  1. Select your Azure Database for PostgreSQL flexible server.

  2. In the resource menu, under the Settings section, select Maintenance.

    Screenshot showing the Maintenance page.

  3. If you select System-managed schedule, the system automatically assigns a random day of the week, and a 60-minute window that begins somewhere between 11 PM and 7 AM (local server time).

    Screenshot showing the selection of system managed schedule in Maintenance page.

  4. If you want more granular control, select Custom schedule.

    Screenshot showing the selection of custom schedule in Maintenance page.

  5. Select a preferred day of the week, and a start time for the 60-minute window in which you want maintenance to occur.

    Screenshot showing the selection of custom day of the week and start time for the maintenance window.

  6. Select Save.

    Screenshot showing how to save configuration changes made to Maintenance page.

  7. Make sure that you understand the implications of changing the currently configured schedule and confirm the operation or cancel it.

    Screenshot showing how to confirm or cancel configuration changes made to Maintenance schedule.

  8. A notification informs you that the service is updating the maintenance window settings.

    Screenshot showing the notification informing that configuration changes are being applied.

  9. When the operation finishes, a notification informs you that the service completed the update of the maintenance window settings.

    Screenshot showing the notification informing that configuration changes were successfully applied.

Notifications about scheduled maintenance events

You can use Azure Service Health to view notifications about upcoming and performed scheduled maintenance on your Azure Database for PostgreSQL flexible server instance.

You can also set up alerts in Azure Service Health to get notifications about maintenance events.