Hide Forgot
Description of problem: To gather more data when checking support cases, having 'log_min_duration = 1000' in PostgreSQL config by default would be great. Expected results: 'log_min_duration = 500' should be in PostgreSQL config file on both freshly installed and upgraded Satellite: # grep log_min_duration /var/lib/pgsql/data/postgresql.conf Additional info: Tuning profiles already have 'log_min_duration = 500' https://github.com/RedHatSatellite/satellite-support/tree/master/tuning-profiles Note this can be also achieved via /etc/foreman-installer/custom-hiera.yaml by: postgresql::server::config_entries: log_min_duration_statement: 1000
Created redmine issue https://projects.theforeman.org/issues/27846 from this bug
The title says 1000 but the expected result states 500. Which one should it be? In https://github.com/theforeman/foreman-installer/pull/389 I went with 1000 since that feels like a safer default to me.
I'm very sorry for confusion. Make it "1000" for start.
Upstream bug assigned to ekohlvan@redhat.com
This can wait for 6.7.0 release, removing the 6.6.z flag.
Verified this issue with 6.7 Snap 10 on the upgraded as well as freshly installed setup. # rpm -q satellite-installer satellite-installer-6.7.0.6-1.beta.el7sat.noarch grep log_min_duration /var/lib/pgsql/data/postgresql.conf #log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements log_min_duration_statement = 1000
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