Ensure that the "max_connections" database flag configured for your Google Cloud PostgreSQL database instances has the optimal value, in accordance with your organization or project guidelines. Prior to running this conformity rule by the Trend Micro Cloud One™ – Conformity engine, you need to define the "max_connections" flag minimum value used within your organization in the rule settings, on your Trend Micro Cloud One™ – Conformity account console.
Generally, depending on the plan used, the maximum number of client connections for Google Cloud PostgreSQL databases instances is relatively low. If the "max_connections" configuration flag is set to a low value, is not going to allow a high-traffic application to handle all the work that the users give to it. You can increase the connection limit by configuring "max_connections" configuration flag to meet the database workload requirements chosen by your organization. The new limit cannot exceed 262143 connections.
Note: Some database flag settings can affect instance availability and/or stability, and eventually remove the PostgreSQL instance from the Google Cloud SQL Service Level Agreement (SLA).
To determine if the "max_connections" flag set for your Cloud PostgreSQL database instances has the appropriate configuration, perform the following operations:
Remediation / Resolution
To configure the "max_connections" database flag value in accordance with your organization and project guidelines, perform the following actions:
- Google Cloud Platform (GCP) Documentation
- Cloud SQL for PostgreSQL
- Configuring database flags
- Editing instances
- PostgreSQL Database Documentation
- 19.8. Error Reporting and Logging
Unlock the Remediation Steps
Gain free unlimited access
to our full Knowledge Base
Over 750 rules & best practices
Get started for FREE
You are auditing:
Configure "max_connections" Flag for PostgreSQL Database Instances
Risk level: Medium