PostgreSQL Database configuration ‘log_connections’ should be on

Description

Enabling log_connections helps PostgreSQL Database to log attempted connections 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.

Console Remediation Steps

CLI Remediation Steps

  • To enable log_connections:

az postgres server configuration set --resource-group <resourceGroupName> --server-name <serverName> --name log_connections --value on