Microsoft AzureOverview
Enable log_connections on PostgreSQL Database Servers.
Rationale
Enabling log_connections helps the PostgreSQL Database log attempted connections to the server and successful client authentications. Log data can be used to identify, troubleshoot, and repair configuration errors and sub-optimal performance.
Default value
By default, log_connections is set to on (enabled).
Remediation guidance
Remediate from Azure Portal
- Open the server using the
Open in Azurebutton - Under
Settings, clickServer parameters. - In the filter bar, type
log_connections. - Set
log_connectionstoON. - Click
Save.
Remediate from Azure CLI
Use the below command to update log_connections configuration.
az postgres server configuration set --resource-group <resourceGroupName> --server-name <serverName> --name log_connections --value on
Remediate from PowerShell
Use the below command to update log_connections configuration.
Update-AzPostgreSqlConfiguration -ResourceGroupName -ServerName -Name log_connections -Value on
Service-wide remediation
Recommended when many resources are affected: fix the platform baseline first so new resources inherit the secure setting, then remediate the existing flagged resources in batches.
Azure
Use management group or subscription Azure Policy assignments, remediation tasks where supported, landing-zone standards, and IaC modules so drift is prevented at scale.
Operational rollout
- Fix the baseline first at the account, subscription, project, cluster, or tenant scope that owns this control.
- Remediate the currently affected resources in batches, starting with internet-exposed and production assets.
- Re-scan and track approved exceptions with an owner and expiry date.
Query logic
These are the stored checks tied to this control.
Server parameter 'log_connections' is set to 'ON' for PostgreSQL Database Server
Connectors
Covered asset types
Expected check: eq []
{
postgreSqlServers(
where: {
configurations_SOME: { name: "log_connections", value_MATCHES: "(?i)off" }
}
) {
...AssetFragment
}
}
