Control: Geo-redundant backup should be enabled for Azure Database for PostgreSQL
Azure Database for PostgreSQL allows you to choose the redundancy option for your database server. It can be set to a geo-redundant backup storage in which the data is not only stored within the region in which your server is hosted, but is also replicated to a paired region to provide recovery option in case of a region failure. Configuring geo-redundant storage for backup is only allowed during server create.
Run the control in your terminal:
steampipe check azure_compliance.control.postgres_db_server_geo_redundant_backup_enabled
Snapshot and share results via Steampipe Cloud:
steampipe loginsteampipe check --share azure_compliance.control.postgres_db_server_geo_redundant_backup_enabled
This control uses a named query:postgres_db_server_geo_redundant_backup_enabled