Ensure that Storage Auto-Growth feature is enabled for your production Azure PostgreSQL database servers. Storage auto-growth prevents your PostgreSQL servers from running out of storage and becoming read-only.
This rule resolution is part of the Conformity solution.
When working with production data and the database storage auto-growth is enabled, the disk storage automatically grows without impacting the workload. You can add additional storage capacity during and after the creation of the PostgreSQL server, and allow the system to grow storage automatically based on the storage consumption of your workload. For PostgreSQL database servers with less than equal to 100GB provisioned storage, the provisioned storage size is increased by 5GB as soon as the free storage is below 10% of the provisioned storage space. For database servers with more than 100 GB of provisioned storage, the provisioned storage size is increased by 5% when the free storage space is below 5% of the provisioned storage size.
Audit
To determine if storage auto-growth is enabled for your Azure PostgreSQL database servers, perform the following actions:
Remediation / Resolution
To enable storage auto-growth for your production Azure PostgreSQL database servers, perform the following actions:
References
- Azure Official Documentation
- Azure Database for PostgreSQL - Single Server
- Pricing tiers in Azure Database for PostgreSQL - Single Server
- Azure Command Line Interface (CLI) Documentation
- az postgres server list
- az postgres server show
- az postgres server update
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:
Enable Storage Auto-Growth
Risk Level: High