Re: [GENERAL] Postgres 9.6.2 and pg_log

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

 

De : David G. Johnston [mailto:]
Envoyé : Monday, April 24, 2017 1:34 PM
À : Mark Watson
Cc : ()
Objet : Re: [GENERAL] Postgres 9.6.2 and pg_log

 

On Mon, Apr 24, 2017 at 8:43 AM, Mark Watson <> wrote:

Good day all,

 

I just noticed an anomaly regarding the logging. I have my logging set up as follows:

log_filename = 'postgresql-%d.log'

log_truncate_on_rotation = on

 

​I don't see "log_rotation_age" and/or "log_rotation_size" here [1] and at least one needs to be set in order to enable actual rotation; the "truncate" option simply tells PostgreSQL what to do when encountering a file with the same name during the rotation process.​

 

log_rotation_age apparently has under-documented intelligence since I would expect a server that starts up mid-hour and uses a 60 minute rotation to rotate mid-hour as well so the log would contain 1 hours worth of data but the leading hours would be different.  The examples in log_truncate_on_rotation indicate that this isn't the case.  I have not tested reality or read the source.

 

This is on Windows 10, 64-bit

PostgreSQL 9.2.2, compiled by Visual C++ build 1800, 64-bit

(EnterpriseDB installer)

 

Note that this is not a major concern on my end; postgres 9.6.2 has otherwise been running flawlessly.

 

 

​Um...you're reporting a very outdated 9.2 release in the supposed copy-paste job above but claiming 9.6.2 ...

 

 

David J.

Sorry about the version; I queried SELECT version() in pgAdmin4 and did not copy/paste the results. It is version 9.6.2.

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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [GENERAL] Protocol 2 and query parameters support
Следующее
От: Andres Freund
Дата:
Сообщение: [GENERAL] Questionaire: Common WAL write rates on busy servers.