De : David G. Johnston [mailto:david.g.johns...@gmail.com]
Envoyé : Monday, April 24, 2017 2:18 PM
À : Mark Watson
Cc : (pgsql-general@postgresql.org)
Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log

On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson 
<mark.wat...@jurisconcept.ca<mailto:mark.wat...@jurisconcept.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

Reply via email to