Configure scheduled maintenance

APPLIES TO: 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.

Specify scheduled maintenance options

Using 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 which begins somewhere between 11pm and 7am (local server time).

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

  4. If you want to have more granular control, select Custom schedule. You can then 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 schedule in Maintenance page.

  5. Select Save.

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

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

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

  7. Once the operation ends, 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.

Share your suggestions and bugs with the Azure Database for PostgreSQL product team.