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.
A reasonable log_rotation_size should be set to prevent /var/lib/pgsql being filled up.
As per the email discussion, log_rotation_size of 200MB will be implemented to resolve this issue:
Created redmine issue https://projects.theforeman.org/issues/28497 from this bug
Moving this bug to POST for triage into Satellite 6 since the upstream issue https://projects.theforeman.org/issues/28497 has been resolved.
Verified on 6.7 Snap11.
#rpm -q foreman-installer
log_line_prefix: '%t '
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.
For information on the advisory, and where to find the updated
files, follow the link below.
If the solution does not work for you, open a new bug report.