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 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.
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 that begins somewhere between 11 PM and 7 AM (local server time).
If you want 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.
Make sure that you understand the implications of changing the currently configured schedule and confirm the operation or cancel it.
A notification informs you that the service is updating the maintenance window settings.
When the operation finishes, a notification informs you that the service completed the update of the maintenance window settings.
Steps to view upcoming maintenance
Using the Azure portal:
Select 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. That 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
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server.
In the resource menu, under the Settings section, 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's an upcoming maintenance event and the event is eligible for rescheduling. Some events aren't eligible, especially if they're required for critical security or compliance reasons.
I can't select the date or time I want
You can select only eligible future maintenance slots. 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 isn't available 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 that are already on a custom maintenance schedule. Any changes to the maintenance schedule take effect on the next maintenance event.
Steps to apply maintenance on demand
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server.
In the resource menu, under the Settings section, 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 moves to the maintenance history section.
Steps to view maintenance history
Using the Azure portal:
Select your Azure Database for PostgreSQL flexible server.
In the resource menu, under the Settings section, 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.
You can also set up alerts in Azure Service Health to get notifications about maintenance events.