Skip to content

Latest commit

 

History

History
26 lines (21 loc) · 2.28 KB

log-retention-period.md

File metadata and controls

26 lines (21 loc) · 2.28 KB

CloudSploit

AZURE / PostgreSQL Server / Log Retention Period

Quick Info
Plugin Title Log Retention Period
Cloud AZURE
Category PostgreSQL Server
Description Ensures logs are configured to be retained for 4 or more days for PostgreSQL servers
More Info Having a long log retention policy ensures that all critical logs are stored for long enough to access and view in case of a security incident.
AZURE Link https://docs.microsoft.com/en-us/azure/postgresql/howto-configure-server-parameters-using-portal
Recommended Action Ensure the server parameters for each PostgreSQL server have the log_retention_days setting set to 4 or more days.

Detailed Remediation Steps

  1. Log in to the Microsoft Azure Management Console.
  2. Select the "Search resources, services, and docs" option at the top and search for PostgreSQL.
  3. On the "Azure Database for PostgreSQL servers" page, select the database by clicking on the "Name" as a link that needs to be examined.
  4. Scroll down the left navigation panel and choose "Server parameters" under "Settings."
  5. On the "Server parameters" page, search for "log_retention_days" paramter using the "Search for filter item search box." If the value is set to less than "3 days" then the "log_retention_days" is not as per best practices for PostgreSQL servers.
  6. To increase the value of log_retention_days set the "log_retention_days" by typing the "Value" to more than "4" days in the textbox.
  7. Click on the "Save" button at the top to make the changes.
  8. Repeat step number 3 - 7 to ensure the server parameters for each PostgreSQL server have the log_retention_days setting set to 4 or more days.