Control: 6.8 Ensure server parameter 'log_disconnections' is set to 'ON' for PostgreSQL Database Server
Description
Enable log_disconnections on PostgreSQL Servers.
Remediation
From Console
- Login 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_disconnections
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_8
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run alicloud_compliance.control.cis_v100_6_8 --share
SQL
This control uses a named query:
rds_instance_postgresql_log_disconnections_parameter_on