Azure / Azure/azure-postgresql

Cannot deploy postgres configurations without having to create arbitrary wait script

Open
#134 0 comments 2 reactions 0 assignees View on GitHub
Dominant language
Bicep
Stars
87
Forks
81
PR merge metrics
No merged PRs in 30d

Description

Deploying a server and postgres configuration like this:

```

resource pgServer 'Microsoft.DBforPostgreSQL/flexibleServers@2025-08-01' = {
name: 'somePgServerName'
location: location
sku: {
...
}
properties: {
version: '17'
...
}
}

resource cfgQueryCaptureMode 'Microsoft.DBforPostgreSQL/flexibleServers/configurations@2025-08-01' = {
name: 'pg_qs.query_capture_mode'
parent: pgServer
properties: {
source: 'user-override'
value: 'ALL'
}
}
```

will usually fail with

> `"code":"ServerIsBusy","message":"Cannot complete operation while server 'somePgServerName' is busy processing another operation. Try again later."`

The "fix" is to insert a deployment script does an arbitrary wait - I found even a 1sec sleep works, so I assume the time it takes to provision the deployment script is about the time it takes for postgres to settle down.

This has been verified with Azure technical support.

Could the postgres provider please be changed to accept config changes without having to insert arbitrary wait scripts?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.