Control: 6.7 Ensure parameter 'log_connections' is set to 'ON' for PostgreSQL Database
Description
Enable log_connections 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_connection
parameter next theActual 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_7
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run alicloud_compliance.control.cis_v100_6_7 --share
SQL
This control uses a named query:
rds_instance_postgresql_log_connections_parameter_on