Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Postgres 9.6.2 and pg_log - Mailing list pgsql-general

From David G. Johnston
Subject Re: [GENERAL] Postgres 9.6.2 and pg_log
Date
Msg-id CAKFQuwbVkhmNoO74Y-TG=xrUKFH_wRquZmqDihjpmNGbqqUhHQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Postgres 9.6.2 and pg_log  (Mark Watson <mark.watson@jurisconcept.ca>)
Responses Re: [GENERAL] Postgres 9.6.2 and pg_log  (Mark Watson <mark.watson@jurisconcept.ca>)
List pgsql-general
Tree view
On Mon, Apr 24, 2017 at 10:58 AM, Mark Watson <mark.watson@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.

pgsql-general by date:

Previous
From: Edmundo Robles
Date:
Subject: [GENERAL] changing type of column on partitionated table.
Next
From: Mark Watson
Date:
Subject: Re: [GENERAL] Postgres 9.6.2 and pg_log