turbot/alicloud_compliance

GitHub
Loading controls...

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

  1. Login to RDS Console.
  2. In the upper-left corner, select the region of the target instance.
  3. Locate the target instance, and click the instance ID to enter the Basic Information page.
  4. In the left-side navigation pane, select Parameters.
  5. Click the Edit icon of log_disconnections parameter next the Actual Value column.
  6. Enter On as the Actual Value and click Confirm.
  7. Click Apply Changes.
  8. In the message that appears, click Confirm.

Usage

Run the control in your terminal:

steampipe check alicloud_compliance.control.cis_v100_6_8

Snapshot and share results via Steampipe Cloud:

steampipe login
steampipe check --share alicloud_compliance.control.cis_v100_6_8

SQL

This control uses a named query:

rds_instance_postgresql_log_disconnections_parameter_on

Tags