[pgpool-general: 9287] Re: differentiating settings that support units

[Bo Peng]

Hi,

Thank you  for reporting this issue.

> But some settings, such as:
> * health_check_timeout (integer)
> * health_check_period (integer)
> also specify it is an "interval" but they do *not* support units.
> Specifying units, will result in errors during startup (tested on 4.5.5):
>
> Questions:
> * should "health_check_*" related settings support interval units?
> * should docs differentiate settings that support "units" and show
> some other indicator next to the setting instead of just "(integer)" -
> for example "(integer,units)", "(float,units)"?
> _______________________________________________

Currently, health_check_period and health_check_timeout do not support units.
If you want to specify units, you need to configure the settings as follows:

(For example, if there are two PostgreSQL nodes)

health_check_period0 = 10s  
health_check_period1 = 11s  

I will check if they can be changed to allow units.

On Sun, 8 Dec 2024 11:03:56 -0500
zam bak <zam6ak at gmail.com> wrote:

> According to https://www.pgpool.net/docs/45/en/html/config-setting.html,
> there is a distinction between "numeric" settings ("integers",
> "floats"), and "numeric with unit" settings.
> 
> For each setting then there is an indicator (in parentheses) of what
> type it accepts...
> 
> But some settings indicate "integer" even though they accept "numeric
> with units".
> For example:
> * delay_threshold_by_time (integer)
> * sr_check_period (integer)
> Side note - documentation details are clear that these are intervals
> in seconds (which gives a hint that you can use units)
> 
> But some settings, such as:
> * health_check_timeout (integer)
> * health_check_period (integer)
> also specify it is an "interval" but they do *not* support units.
> Specifying units, will result in errors during startup (tested on 4.5.5):
> 2024-12-08 10:38:19.039 [34300]: [1-1] user=[No Connection],db=[No
> Connection],app=main FATAL:  invalid value for parameter
> "health_check_period": "10s"
> 2024-12-08 10:39:03.872 [34328]: [1-1] user=[No Connection],db=[No
> Connection],app=main FATAL:  invalid value for parameter
> "health_check_timeout": "30s"
> 
> 
> Questions:
> * should "health_check_*" related settings support interval units?
> * should docs differentiate settings that support "units" and show
> some other indicator next to the setting instead of just "(integer)" -
> for example "(integer,units)", "(float,units)"?
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS K.K.
TEL: 03-5979-2701 FAX: 03-5979-2702
URL: https://www.sraoss.co.jp/