Azure / Azure/azure-postgresql
Cannot deploy postgres configurations without having to create arbitrary wait script
- 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.