Issue: authentication_timeout parament change take effect with reload, however the table say it need restart to take affect.
Given:
authentication_timeout
Maximum time to complete client authentication. This prevents hung clients from occupying a connection
indefinitely.
Value Range
Any valid time expression
(number and unit)
Default
1min
Set Classifications
local
system
restart
Testing:
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -s authentication_timeout
Values on all segments are consistent
GUC : authentication_timeout
Master value: 1min
Segment value: 1min
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -c authentication_timeout -v 2min
20210708:17:45:10:000949 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c authentication_timeout -v 2min'
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpstop -u
20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u
20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment...
20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master...
20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c'
20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -s authentication_timeout
Values on all segments are consistent
GUC : authentication_timeout
Master value: 2min
Segment value: 2min
[gpadmin@mdw_ipv4 ~]$
Page No : 1317
Issue: authentication_timeout parament change take effect with reload, however the table say it need restart to take affect.
Given:
authentication_timeout Maximum time to complete client authentication. This prevents hung clients from occupying a connection indefinitely. Value Range
Any valid time expression (number and unit) Default 1min Set Classifications local system restart
Testing: [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s authentication_timeout Values on all segments are consistent GUC : authentication_timeout Master value: 1min Segment value: 1min [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c authentication_timeout -v 2min 20210708:17:45:10:000949 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c authentication_timeout -v 2min' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210708:17:45:24:001034 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s authentication_timeout Values on all segments are consistent GUC : authentication_timeout Master value: 2min Segment value: 2min [gpadmin@mdw_ipv4 ~]$