Skip to content

Latest commit

 

History

History
55 lines (33 loc) · 2.91 KB

how-to-restart-server-portal.md

File metadata and controls

55 lines (33 loc) · 2.91 KB
Raw
title description ms.service ms.subservice ms.topic ms.author author ms.date
Restart server - Azure portal - Azure Database for PostgreSQL - Single Server
This article describes how you can restart an Azure Database for PostgreSQL - Single Server using the Azure portal.
azure-database-postgresql
single-server
how-to
sunila
sunilagarwal
06/24/2022

Restart Azure Database for PostgreSQL - Single Server using the Azure portal

[!INCLUDE applies-to-postgresql-single-server]

[!INCLUDE azure-database-for-postgresql-single-server-deprecation]

This topic describes how you can restart an Azure Database for PostgreSQL server. You may need to restart your server for maintenance reasons, which causes a short outage as the server performs the operation.

The server restart will be blocked if the service is busy. For example, the service may be processing a previously requested operation such as scaling vCores.

Note

The time required to complete a restart depends on the PostgreSQL recovery process. To decrease the restart time, we recommend you minimize the amount of activity occurring on the server prior to the restart. You may also want to increase the checkpoint frequency. You can also tune checkpoint related parameter values including max_wal_size. It is also recommended to run CHECKPOINT command prior to restarting the server to enable faster recovery time. If the CHECKPOINT command is not performed prior to restarting the server then it may lead to longer recovery time.

Prerequisites

To complete this how-to guide, you need:

Perform server restart

The following steps restart the PostgreSQL server:

  1. In the Azure portal, select your Azure Database for PostgreSQL server.

  2. In the toolbar of the server's Overview page, select Restart.

    :::image type="content" source="./media/how-to-restart-server-portal/2-server.png" alt-text="Azure Database for PostgreSQL - Overview - Restart button":::

  3. Select Yes to confirm restarting the server.

    :::image type="content" source="./media/how-to-restart-server-portal/3-restart-confirm.png" alt-text="Azure Database for PostgreSQL - Restart confirm":::

  4. Observe that the server status changes to "Restarting".

    :::image type="content" source="./media/how-to-restart-server-portal/4-restart-status.png" alt-text="Azure Database for PostgreSQL - Restart status":::

  5. Confirm server restart is successful.

    :::image type="content" source="./media/how-to-restart-server-portal/5-restart-success.png" alt-text="Azure Database for PostgreSQL - Restart success":::

Next steps

Learn about how to set parameters in Azure Database for PostgreSQL