Ensure server parameter 'logfiles.retention_days' is greater than 3 days for PostgreSQL flexible server
Why This Matters
Log retention periods that are too short can prevent administrators from investigating past security incidents or performance issues. Without sufficient log history, it becomes difficult to identify patterns of unauthorized access, troubleshoot configuration errors, or diagnose suboptimal database performance. Proper retention of query and error logs is essential for maintaining operational visibility and meeting compliance requirements.
What Aether365 Checks
Aether365 verifies that the logfiles.retention_days server parameter on each Azure Database for PostgreSQL flexible server is configured to a value greater than 3 days. This check appears in the Aether365 dashboard under the azure-postgresql-configuration checks section.
How to Fix
Follow these steps to configure log retention on a PostgreSQL flexible server: