Benchmark: PostgreSQL
Description
This benchmark provides a set of controls that detect Terraform Azure PostgreSQL resources deviating from security best practices.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-terraform-azure-complianceStart the Powerpipe server:
steampipe service startpowerpipe serverOpen http://localhost:9033 in your browser and select PostgreSQL.
Run this benchmark in your terminal:
powerpipe benchmark run terraform_azure_compliance.benchmark.postgresSnapshot and share results via Turbot Pipes:
powerpipe benchmark run terraform_azure_compliance.benchmark.postgres --shareControls
- PostgreSQL flexible serves Geo-redundant backup should be enabled
- Enable connection_throttling on PostgreSQL Servers
- Geo-redundant backup should be enabled for Azure Database for PostgreSQL
- PostgreSQL Servers should use at least TLS 1.2 version
- Enable log_checkpoints on PostgreSQL Servers
- Enable log_connections on PostgreSQL Servers
- Enable log_disconnections on PostgreSQL Servers
- Enable log_retention_days on PostgreSQL Servers
- PostgreSQL Servers threat detection policy should be enabled
- PostgreSQL servers should use customer-managed keys to encrypt data at rest
- Infrastructure encryption should be enabled for Azure Database for PostgreSQL servers
- Public network access should be disabled for PostgreSQL servers
- Enforce SSL connection should be enabled for PostgreSQL database servers