Azure_DBPostgreSQL_4

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

Description

Enable log_disconnections 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_disconnections
  5. Click ON and save.

Perform the following in Azure Command Line Interface 2.0:

Use the below command to update log_disconnections configuration.

az postgres server configuration set –resource-group <resourceGroupName> –server-name <serverName> –name log_disconnections –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!