More Info:
Ensure that “log_duration” server parameter is enabled for all PostgreSQL database servers created in your Microsoft Azure cloud account. Once enabled, the “log_duration” parameter allows recording the duration of each completed PostgreSQL statement. Only users with administrative privileges can change this setting within Azure PostgreSQL server configuration. For database clients using extended query protocol, the duration of the “Parse”, “Bind”, and “Execute” steps is logged independently.Risk Level
MediumAddress
SecurityCompliance Standards
HITRUST, SOC2, NISTCSF, PCIDSSTriage and Remediation
Remediation
Using Console
Using Console
To remediate the “LOG_DURATION” parameter misconfiguration for PostgreSQL Servers in Azure, you can follow the below steps:
- Log in to the Azure portal (https://portal.azure.com/).
- Navigate to the PostgreSQL server for which you want to enable the “LOG_DURATION” parameter.
- Click on the “Configuration” tab from the left-hand side menu.
- Scroll down to the “Parameters” section and search for the “log_duration” parameter.
- If the “log_duration” parameter is not present, click on the ”+ Add parameter” button and add the parameter.
- Set the value of the “log_duration” parameter to “on” to enable it.
- Click on the “Save” button to save the changes.
Using CLI
Using CLI
To remediate the misconfiguration of enabling the “LOG_DURATION” parameter for PostgreSQL servers in AZURE using AZURE CLI, you can follow the below steps:
- Open the AZURE CLI and log in to your AZURE account.
-
Run the below command to get the list of all the PostgreSQL servers in your subscription:
- Select the PostgreSQL server for which you want to enable the “LOG_DURATION” parameter and note down its resource group name and server name.
-
Run the below command to enable the “LOG_DURATION” parameter for the selected PostgreSQL server:
Replace
<resource_group_name>
and<server_name>
with the actual values of the resource group name and server name noted down in step 3. -
Verify that the “LOG_DURATION” parameter is enabled for the PostgreSQL server by running the below command:
If the output shows the value of “value” parameter as “on”, then the “LOG_DURATION” parameter is enabled for the PostgreSQL server.
Using Python
Using Python
To enable the “LOG_DURATION” parameter for PostgreSQL servers in Azure using python, you can follow the below steps:This should enable the “LOG_DURATION” parameter for the PostgreSQL server in Azure.
- Import the necessary libraries:
- Set the credentials for authentication:
- Create a PostgreSQL management client object:
- Get the PostgreSQL server you want to enable the “LOG_DURATION” parameter for:
- Update the server configuration to enable the “LOG_DURATION” parameter:
- Verify that the configuration has been updated: