Logging and monitoring

RDS PostgreSQL doesn’t have disconnection log

Risk Level

Informational (4)

Platform(s)

Description

Alibaba Cloud ApsaraDB for RDS is an online database service for easy operation, manage and scale relational databases. Enabling 'log_disconnections' allows PostgreSQL Database to log all end of connection sessions including their duration. Configuration issues and inadequate performance can be identified, troubleshooted, and repaired using log data. It was found that the instance '{AliCloudRdsDbInstance}' has 'log_disconnections' set to 'off'.
  • Recommended Mitigation

    It is recommended to set the parameter 'log_disconnections' on the PostgreSQL instance to 'on'. To configure the PostgreSQL parameters, follow the instructions at: <a href="https://www.alibabacloud.com/help/doc-detail/96751.htm" target="_blank" rel="noopener noreferrer">https://www.alibabacloud.com/help/doc-detail/96751.htm</a>