Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
You can specify scheduled maintenance options for each Azure Database for PostgreSQL flexible server instance in your Azure subscription. Options include the type of scheduled maintenance and notification settings for upcoming and finished maintenance events.
Steps to schedule maintenance
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server instance.
In the resource menu, under the Settings section, select Maintenance.
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).
If you want to have more granular control, select Custom schedule.
Select a preferred day of the week, and a start time for the 60-minute window in which you want maintenance to occur.
Select Save.
A notification informs you that the service is updating the maintenance window settings.
Once the operation ends, a notification informs you that the service completed the update of the maintenance window settings.
Steps to view upcoming maintenance
In the Azure portal, go to your Azure Database for PostgreSQL flexible server.
On the server Overview page, review the Next Maintenance field.
If upcoming maintenance is available, the Next Maintenance field displays the scheduled maintenance time.
Select the Next Maintenance value to open the Maintenance page.
On the Maintenance page, review the Maintenance status section.
The Maintenance status section shows upcoming maintenance events that apply to your server, including the scheduled time, status, maintenance type, and available actions.
Steps to reschedule maintenance to a future date
In the Azure portal, go to your Azure Database for PostgreSQL flexible server.
In the left menu, under Settings, select Maintenance.
In the Maintenance status section, review the upcoming maintenance event.
If the event is eligible, select Reschedule.
Choose an eligible future date and time.
Only dates and times that meet the service rules and your maintenance policy are available for selection.
Select Reschedule to confirm the new maintenance time.
After confirmation, review the Maintenance status section to verify that the new start time is displayed.
The portal shows a confirmation after the maintenance event is successfully rescheduled.
Troubleshooting
The Reschedule button isn't available
The Reschedule action appears only when there is an upcoming maintenance event and the event is eligible for rescheduling. Some events might not be eligible, especially if they are required for critical security or compliance reasons.
I can't select the date or time I want
Only eligible future maintenance slots are selectable. The selected time must be within the allowed reschedule window and must comply with the server maintenance policy.
I receive an error that the maintenance window is locked
Rescheduling is unavailable starting 15 minutes before the initially scheduled maintenance time. This lock-in period helps maintain service reliability as the maintenance workflow prepares to start.
I receive an error that maintenance can't be rescheduled or applied now because the custom maintenance window was configured after the event was scheduled
Rescheduling is available only for flexible servers which are already on custom maintenance schedule. Any changes to maintenance schedule will take effect on the next maintenance event.
Steps to apply maintenance on-demand
In the Azure portal, go to your Azure Database for PostgreSQL flexible server.
In the left menu, under Settings, select Maintenance.
In the Maintenance status section, review the upcoming maintenance event.
If the event is eligible, select Reschedule followed by Apply now.
Review the confirmation message.
The confirmation dialog explains that maintenance starts immediately and that the server might restart during the maintenance process.
Select Yes - Apply Maintenance Now to start maintenance.
Monitor the Maintenance status section.
The maintenance event status updates as the workflow progresses. When maintenance completes, the status changes to Complete and it is moved to the maintenance history section
Steps to view maintenance history
In the Azure portal, go to your Azure Database for PostgreSQL flexible server.
In the left menu, under Settings, select Maintenance.
On the Maintenance page, review the Maintenance history section.
Select a maintenance event Tracking ID to view more details, such as the maintenance type, start time, end time, and final status.
Select Export to CSV to download maintenance history.
Note
If no past maintenance events are available for the server, the maintenance history section might be empty.
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.