New Policy (Azure Database for PostgreSQL flexible servers): PostgreSQL flexible servers should log connections

[tdefise]

Policy

• Name: PostgreSQL flexible servers should log connections
• Description: This policy helps audit any PostgreSQL databases in your environment without log_connections setting enabled
• Supported effect(s): AuditIfNotExists, Disabled
• Parameters: None

Description

This policy helps audit any PostgreSQL databases in your environment without log_connections setting enabled

Details

Enabling log_connections helps PostgreSQL Database to log attempted connection to the server, as well as successful completion of client authentication.

Contribution Rules

• [X] Contain a single Policy in a folder by itself with 3 files: azurepolicy.json, azurepolicy.rules.json, and azurepolicy.parameters.json
• [X] Used Confirm-PolicyDefinitionIsValid.ps1
• [X] Used Out-FormattedPolicyDefinition.ps1
• [X] Effect default value alignes with convention