Project

General

Profile

Feature #28497

set log_rotation_size when enabling log_min_duration_statement for PostgreSQL

Added by Suresh Thirugnanasambandan 8 months ago. Updated 8 months ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
Fixed in Releases:
Found in Releases:

Description

Cloned from https://bugzilla.redhat.com/show_bug.cgi?id=1770646

Description of problem:

BZ#1749233 is going to set log_min_duration_statement=1000 for PostgreSQL by default. However, this has a possible side effect on a large deployment where /var/lib/pgsql is mounted separately. The /var/lib/pgsql can be easily filled up
when slow queries are identified. For example, a slow query for selecting facts could consume a large space when there are many facts on a host.

Expected results:

A reasonable log_rotation_size should be set to prevent /var/lib/pgsql being filled up.

Associated revisions

Revision 6c510313 (diff)
Added by Suresh Thirugnanasambandan 8 months ago

Fixes #28497: Add default log_rotation_size configuration for Postgres

History

#1 Updated by Suresh Thirugnanasambandan 8 months ago

  • Assignee changed from Ewoud Kohl van Wijngaarden to Suresh Thirugnanasambandan

#2 Updated by The Foreman Bot 8 months ago

  • Status changed from New to Ready For Testing
  • Pull request https://github.com/theforeman/foreman-installer/pull/432 added

#3 Updated by The Foreman Bot 8 months ago

  • Fixed in Releases 2.0.0 added

#4 Updated by Suresh Thirugnanasambandan 8 months ago

  • Status changed from Ready For Testing to Closed

Also available in: Atom PDF