Server parameter 'log_retention_days' should be greater than 3 days for PostgreSQL Database Server


Enabling log_retention_days helps PostgreSQL Database to set the number of days a log file is retained, which in turn generates query and error logs. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and sub-optimal performance.


From the console

  1. Log in to Azure Portal.
  2. Go to Azure Database for PostgreSQL server.
  3. For each database, click Server parameters.
  4. Search for log_retention_days.
  5. Enter a value in range 4-7 (inclusive) and save.