Description:
Enable 'log_connections' on 'PostgreSQL Servers'.
Rationale:
Enabling 'log_connections' helps PostgreSQL Database to log attempted connection to the server, as well as successful completion of client authentication. Log data can be used to identify, troubleshoot, and repair configuration errors and suboptimal performance.
From Azure Portal
From Azure CLI
Use the below command to update 'log_connections' configuration.
az postgres server configuration set --resource-group --server-name --name log_connections --value on
From PowerShell
Use the below command to update 'log_connections' configuration.
Update-AzPostgreSqlConfiguration -ResourceGroupName -ServerName -Name log_connections -Value on