Control: 6.9 Ensure server parameter 'log_duration is set to 'ON' for PostgreSQL Database Server
Description
Enable log_duration on PostgreSQL Servers.
Remediation
From Console
- Logon to RDS Console.
- In the upper-left corner, select the region of the target instance.
- Locate the target instance, and click the instance ID to enter the
Basic Information
page. - In the left-side navigation pane, select
Parameters
. - Click the
Edit
icon oflog_durantion
parameter next the Actual Value
column. - Enter
On
as theActual Value
and clickConfirm
. - Click
Apply Changes
. - In the message that appears, click
Confirm
.
Usage
Run the control in your terminal:
powerpipe control run alicloud_compliance.control.cis_v100_6_9
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run alicloud_compliance.control.cis_v100_6_9 --share
SQL
This control uses a named query:
rds_instance_postgresql_log_duration_parameter_on