Re: [GENERAL] Postgres 9.6.2 and pg_log

Поиск
Список
Период
Сортировка
От Mark Watson
Тема Re: [GENERAL] Postgres 9.6.2 and pg_log
Дата
Msg-id 02F1BBB48ABD3245A3BC519B57CFC8CA013C3B5B34@Exchange.JurisConcept.local
обсуждение исходный текст
Ответ на Re: [GENERAL] Postgres 9.6.2 and pg_log  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: [GENERAL] Postgres 9.6.2 and pg_log  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general

De : David G. Johnston [mailto:david.g.johnston@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.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" @​

 

 

​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

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [GENERAL] Postgres 9.6.2 and pg_log
Следующее
От: pinker
Дата:
Сообщение: Re: [GENERAL] Block size recommendation for Red Hat Linux 7.2