From: | Mark Watson <mark(dot)watson(at)jurisconcept(dot)ca> |
---|---|
To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
Cc: | "(pgsql-general(at)postgresql(dot)org)" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres 9.6.2 and pg_log |
Date: | 2017-04-24 18:27:32 |
Message-ID: | 02F1BBB48ABD3245A3BC519B57CFC8CA013C3B5B34@Exchange.JurisConcept.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
De : David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
Envoyé : Monday, April 24, 2017 2:18 PM
À : Mark Watson
Cc : (pgsql-general(at)postgresql(dot)org)
Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log
On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson <mark(dot)watson(at)jurisconcept(dot)ca<mailto:mark(dot)watson(at)jurisconcept(dot)ca>> wrote:
The lines log_rotation_age and log_rotation_size are commented, and currently are:
#log_rotation_age = 1d # Automatic rotation of logfiles will
# happen after that time. 0 disables.
#log_rotation_size = 10MB # Automatic rotation of logfiles will
# happen after that much log output.
# 0 disables.
I see from your reference article that the log_rotation_age is now in minutes, and I will adjust that to 1440 (1 day). I don’t know where the “1d” came from. I know it used to be like this in earlier versions.
Those are fine: See "Numeric with Unit" @
https://www.postgresql.org/docs/9.6/static/config-setting.html
I think the actual missing, and (just checked) defaulted off, parameter is "logging_collector"
David J.
I have (copy/paste) :
log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog, and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.
# This is used when logging to stderr:
logging_collector = on # Enable capturing of stderr and csvlog
# into log files. Required to be on for
# csvlogs.
# (change requires restart)
Mark Watson
From | Date | Subject | |
---|---|---|---|
Next Message | pinker | 2017-04-24 18:43:37 | Re: Block size recommendation for Red Hat Linux 7.2 |
Previous Message | David G. Johnston | 2017-04-24 18:18:21 | Re: Postgres 9.6.2 and pg_log |