Re: disabling log_rotation_age feature.

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Re: disabling log_rotation_age feature.
Date: 2014-06-12 06:35:25
Message-ID: 1402554925613-5806948.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

David G Johnston wrote
>
> Tomonari Katsumata-2 wrote
>> Hi,
>>
>> I'm reading about log_rotation_age.
>> And I noticed that the setting for disabling the feature is not clear.
>>
>>
>> The document tells us to set it to ZERO if we want to disable the
>> feature.
>> However, the feature would be disabled if we set it less than one minute.
>>
>> [Example]
>> *******************************************
>> $ grep log_rotation_age ${PGDATA}/postgresql.conf
>> #log_rotation_age = 1d # Automatic rotation of logfiles will
>> log_rotation_age = 10s # Automatic rotation of logfiles will
>>
>> $ psql postgres
>> psql (9.5devel)
>> Type "help" for help.
>>
>> postgres=# show log_rotation_age ;
>> log_rotation_age
>> ------------------
>> 0
>> (1 row)
>> *******************************************
>>
>> I think this fact should be written on document for users.
>>
>> [Fix Example]
>> *********
>> After this many minutes have elapsed, a new log file will
>> - be created. Set to zero to disable time-based creation of
>> + be created. Set to zero or less than one minute to disable time-based
>> new log files.
>> *********
> I suggest documenting, if correct, that maximum resolution is minutes
> (rounding down) and thus any sub-1-minute value will be interpreted as
> zero and disable the feature.
>
> David J.

Note that given the description and the fact only integer is supported the
above is already implied today. I would think specifying a seconds should
result in an error since doing so requires a floating point value.

Is it documented (if true) that any floating point number given to an
integer typed parameter is truncated? Or does the time form with units have
some special behavior?

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/disabling-log-rotation-age-feature-tp5806936p5806948.html
Sent from the PostgreSQL - docs mailing list archive at Nabble.com.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Fujii Masao 2014-06-12 12:26:09 Re: disabling log_rotation_age feature.
Previous Message David G Johnston 2014-06-12 06:28:21 Re: disabling log_rotation_age feature.