Ensure server parameter 'log_connections' is set to 'ON' for PostgreSQL Database Server - azurerm_postgresql_configuration

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 Console

1. Login to Azure Portal using https://portal.azure.com
2. Go to 'Azure Database' for 'PostgreSQL server'
3. For each database, click on 'Server parameters'
4. Search for 'log_connections'.
5. Click 'ON' and save.

Using Azure Command Line Interface 2.0

Use the below command to update 'log_connections' configuration.

az postgres server configuration set --resource-group --server-name --name log_connections --value on
.