Restart PostgreSQL engine in Azure Database for PostgreSQL flexible server

This article provides step-by-step instructions to restart the PostgreSQL engine hosted by an Azure Database for PostgreSQL flexible server.

Important

Restarting the PostgreSQL engine in an Azure Database for PostgreSQL flexible server doesn't restart the compute (virtual machine) that hosts it. It only restarts the database engine process.

Steps to restart PostgreSQL engine

Portal

Use the Azure portal:

1. Select your Azure Database for PostgreSQL flexible server.

2. In the resource menu, select Overview.

   

3. The server status must be Ready for the Restart button to appear on the toolbar.

   

4. Select the Restart button.

   

5. In the Restart server dialog, confirm or cancel your decision to restart the server.

   

6. A notification informs you that the server is restarting. Also, the status of the server changes to Restarting.

   

7. When the process completes, a notification informs you that the server is restarted. Also, the status of the server changes to Ready.

   

CLI

Use the az postgres flexible-server restart command to restart the PostgreSQL engine hosted in a started server.

az postgres flexible-server restart \
  --resource-group <resource_group> \
  --name <server>

If you try to restart the PostgreSQL engine on a server that isn't in the Ready state, you get an error like this:

(ServerIsNotReady) Restart or Stop Server can only be performed on Started servers. Server Name = <server>, Current Server State = Stopped
Code: ServerIsNotReady
Message: Restart or Stop Server can only be performed on Started servers. Server Name = <server>, Current Server State = Stopped

If you try to restart the compute of a server that's processing any other operation, you get an error like this:

(SeverBusyWithOtherOperation) Cannot perform 'Restart' server operation because server '<server>' is busy processing other operation.
Code: SeverBusyWithOtherOperation
Message: Cannot perform 'Restart' server operation because server '<server>' is busy processing other operation.

Note

After the server restarts, all management operations are available for the Azure Database for PostgreSQL flexible server.

Related content

• Start compute of a server.
• Stop compute of a server.
• Configure high availability.