Azure_DBPostgreSQL_3

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

Description

Enable log_connections on PostgreSQL Servers.

Remediation

Perform the following in the 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.

Perform the following in Azure Command Line Interface 2.0:

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

References:

  1. https://docs.microsoft.com/en-us/rest/api/postgresql/configurations/listbyserver

Service

Database Services

Severity

Medium

Compliance

Mapping

We are now live on AWS Marketplace.
The integrated view of your cloud infrastructure is now easier than ever!