Re: disabling log_rotation_age feature. - Mailing list pgsql-docs

From Fujii Masao
Subject Re: disabling log_rotation_age feature.
Date
Msg-id CAHGQGwEPVu2T39Zddvh-CubJ9Ghyz4Gf1-JGqqvu5Ja7m5BJ7w@mail.gmail.com
Whole thread Raw
In response to disabling log_rotation_age feature.  (Tomonari Katsumata <katsumata.tomonari@po.ntts.co.jp>)
Responses Re: disabling log_rotation_age feature.
List pgsql-docs
On Thu, Jun 12, 2014 at 1:43 PM, Tomonari Katsumata
<katsumata.tomonari@po.ntts.co.jp> 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.

That's because log_rotation_age expects the setting value in minutes.

This is not a problem only for log_rotation_age. When setting the parameter
which expects the value in seconds to less than one second, the setting value
is implicitly reset to the default. For example,

postgres=# SHOW tcp_keepalives_idle ;
 tcp_keepalives_idle
---------------------
 7200
(1 row)

postgres=# SET tcp_keepalives_idle TO '10ms';
SET
postgres=# SHOW tcp_keepalives_idle ;
 tcp_keepalives_idle
---------------------
 7200
(1 row)

postgres=# SET tcp_keepalives_idle TO '1024ms';
SET
postgres=# SHOW tcp_keepalives_idle ;
 tcp_keepalives_idle
---------------------
 1
(1 row)

Regards,

--
Fujii Masao


pgsql-docs by date:

Previous
From: David G Johnston
Date:
Subject: Re: disabling log_rotation_age feature.
Next
From: Tom Lane
Date:
Subject: Re: disabling log_rotation_age feature.