Shut down Azure PostgreSQL without Azure restarting it automatically

Question

Shut down Azure PostgreSQL without Azure restarting it automatically

Pablo Schor 0

I created an Azure PostgreSQL database and when I shut it down I don't want it to restart automatically, how to fix that? This is what I get every time I shut down the database:

posgres 7 days

Prasad Chaganti 80 Reputation points Microsoft External Staff

2025-03-11T19:19:50.76+00:00
Hi Pablo Schor,

I understand that you are using an Azure Database for PostgreSQL – Flexible Server. It states that the server will automatically restart after 7 days if not manually started before then.

You can create an Azure Automation runbook or use Azure CLI to automatically stop the server every 7 days:

az postgres flexible-server stop --name <server-name> --resource-group <resource-group>

If you want to reduce costs instead of stopping it, scale the server down to the smallest size.

If you don't need the database, you can back up the data and delete the server to stop billing entirely.

Please follow the below steps to Create an Azure Automation Runbook to Stop the Server Automatically:

To automate stopping your Azure PostgreSQL Flexible Server every 7 days (or on a custom schedule), you can create an Azure Automation Runbook using the Azure CLI or PowerShell.

1.Need to create an Automation Account:

Open the Azure Portal and search for Automation Accounts.

Click the Create and fill the details

Subscription, Resource Group, Region, Name(StopPostgresRunbook)

2.Create a Runbook

Go to your Automation Account → Runbooks → Create a Runbook.

please set the following details

Name: StopPostgresFlexibleServer

Runbook Type: PowerShell

Description: "Stops PostgreSQL Flexible Server every 7 days."

3.Please follow the PowerShell script into the runbook:

param ( [string]$ResourceGroupName = "<your-resource-group>", [string]$ServerName = "<your-server-name>" ) # Connect to Azure Connect-AzAccount -Identity # Stop the PostgreSQL Flexible Server Stop-AzPostgreSqlFlexibleServer -ResourceGroupName $ResourceGroupName -Name $ServerName Write-Output "Stopped PostgreSQL server $ServerName in resource group $ResourceGroupName"

4.Save the script → Publish the runbook.

5.Create a Schedule to Run Every 7 Days

Go to the Runbook → Schedules → Add a Schedule.

Please Set the following:

Frequency: Recurring

Every: 7 days

Start Time: Set your preferred start time

Assign Permissions

Go to Automation Account → Identity → System Assigned → Turn it ON.

Go to Azure Role Assignments → Add role assignment

Role: Contributor

Scope: Resource Group

This will automatically stop the PostgreSQL Flexible Server every 7 days. If you want to modify the schedule or settings, you can adjust it in the Automation Account.

I hope this information helps. Please do let us know if you have any further queries.
Prasad Chaganti 80 Reputation points Microsoft External Staff

2025-03-12T23:15:02.3466667+00:00

Hi Pablo Schor,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Your answer

Prasad Chaganti 80 Reputation points Microsoft External Staff

2025-03-12T23:15:02.3466667+00:00

Hi Pablo Schor,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.

Share via

Shut down Azure PostgreSQL without Azure restarting it automatically

Your answer