Description:
Enable 'connection_throttling' on 'PostgreSQL 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.
From Azure Portal
From Azure CLI
Use the below command to update 'connection_throttling' configuration.
az postgres server configuration set --resource-group --server-name --name connection_throttling --value on
From PowerShell
Use the below command to update 'connection_throttling' configuration.
Update-AzPostgreSqlConfiguration -ResourceGroupName -ServerName -Name connection_throttling -Value on