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.
efficiency
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).
Audit
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:
References
- Google Cloud Platform (GCP) Documentation
- Cloud SQL for PostgreSQL
- Configuring database flags
- Editing instances
- PostgreSQL Database Documentation
- 19.8. Error Reporting and Logging
- GCP Command Line Interface (CLI) Documentation
- gcloud projects list
- gcloud sql instances list
- gcloud sql instances describe
- gcloud sql instances patch
Unlock the Remediation Steps
Free 30-day Trial
Automatically audit your configurations with Conformity
and gain access to our cloud security platform.
You are auditing:
Configure "max_connections" Flag for PostgreSQL Database Instances
Risk Level: Medium