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.
As per the email discussion, log_rotation_size of 200MB will be implemented to resolve this issue: log_rotation_size: 200000
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 foreman-installer-1.24.1.6-1.el7sat.noarch #cat /usr/share/foreman-installer/config/foreman.hiera/tuning/common.yaml --- lookup_options: postgresql::server::config_entries: merge: hash apache::mod::passenger::passenger_max_pool_size: 12 apache::mod::passenger::passenger_max_instances_per_app: 6 apache::mod::passenger::passenger_max_request_queue_size: 250 apache::mod::passenger::passenger_stat_throttle_rate: 120 apache::mod::passenger::passenger_max_requests: 10000 apache::mod::passenger::passenger_min_instances: 1 apache::mod::passenger::passenger_max_preloader_idle_time: 0 qpid::open_file_limit: 65536 qpid::router::open_file_limit: 150100 postgresql::server::config_entries: checkpoint_completion_target: 0.9 max_connections: 500 shared_buffers: 512MB work_mem: 4MB log_line_prefix: '%t ' log_min_duration_statement: 1000 log_rotation_size: 200000
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. https://access.redhat.com/errata/RHSA-2020:1454