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