Project

General

Profile

Actions

Bug #27846

closed

by default 'log_min_duration = 1000' should be configured for PostgreSQL

Added by Ewoud Kohl van Wijngaarden almost 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Category:
-
Target version:
-
Fixed in Releases:
Found in Releases:

Description

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:

  1. 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

By including it as default, users can only disable it by setting the value to -1 in custom-hiera.yaml.

Actions #1

Updated by The Foreman Bot almost 5 years ago

  • Status changed from New to Ready For Testing
  • Assignee set to Ewoud Kohl van Wijngaarden
  • Pull request https://github.com/theforeman/foreman-installer/pull/389 added
Actions #2

Updated by The Foreman Bot almost 5 years ago

  • Fixed in Releases 1.24.0 added
Actions #3

Updated by Ewoud Kohl van Wijngaarden almost 5 years ago

  • Status changed from Ready For Testing to Closed
Actions #4

Updated by The Foreman Bot almost 5 years ago

  • Pull request https://github.com/theforeman/foreman-installer/pull/392 added
Actions

Also available in: Atom PDF