Project

General

Profile

Actions
Copy link

Feature #28497

closed

set log_rotation_size when enabling log_min_duration_statement for PostgreSQL

Added by Suresh Thirugnanasambandan almost 5 years ago. Updated almost 5 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Suresh Thirugnanasambandan
Category:
-
Target version:
-
Difficulty:
Triaged:
No
Bugzilla link:
1770646
Pull request:
https://github.com/theforeman/foreman-installer/pull/432
Fixed in Releases:
Foreman - 2.0.0
Found in Releases:
Red Hat JIRA:

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.

Actions
Copy link

Also available in: Atom PDF