Information
Enable connection throttling on PostgreSQL flexible servers.
Rationale:
Enabling connection throttling helps the PostgreSQL Database to Set the verbosity of logged messages. This in turn generates query and error logs with respect to concurrent connections that could lead to a successful Denial of Service (DoS) attack by exhausting connection resources. A system can also fail or be degraded by an overload of legitimate users. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and sub-optimal performance.
Solution
Remediate from Azure Portal
Login to Azure Portal using https://portal.azure.com.
Go to Azure Database for PostgreSQL flexible servers.
For each database, under Settings, click Server parameters.
In the filter bar, type connection_throttle.enable.
Set connection_throttle.enable to ON.
Click Save.
Remediate from Azure CLI
Use the below command to enable connection_throttle.enable:
az postgres flexible-server parameter set --resource-group <resourceGroup> --server-name <serverName> --name connection_throttle.enable --value on
Remediate from PowerShell
Use the below command to update connection_throttling configuration.
Update-AzPostgreSqlFlexibleServerConfiguration -ResourceGroupName <resourceGroup> -ServerName <serverName> -Name connection_throttle.enable -Value on
Default Value:
By default, connection_throttle.enable is disabled (set to off).