Parameter Default value issue

[bala-cg]

Page No : 1391

1) Issue: superuser_reserved_connections Default value is shown 3 postgresql.conf file, but gpconfig -s returns 10.

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# gpadmin=# show superuser_reserved_connections; superuser_reserved_connections

10 (1 row)

gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s superuser_reserved_connections Values on all segments are consistent GUC : superuser_reserved_connections Master value: 10 Segment value: 10 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ grep superuser_reserved_connections $MASTER_DATA_DIRECTORY/postgresql.conf

superuser_reserved_connections = 3 # (change requires restart)

[gpadmin@mdw_ipv4 ~]$

2) Issue: tcp_keepalives_count, Default value is shown different, this parameter is allowed to set at session level.

testing:

[gpadmin@mdw_ipv4 ~]$ gpconfig -s tcp_keepalives_count Values on all segments are consistent GUC : tcp_keepalives_count Master value: 9 Segment value: 9 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# gpadmin=# show tcp_keepalives_count; tcp_keepalives_count

0 (1 row)

gpadmin=# gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ grep tcp_keepalives_count $MASTER_DATA_DIRECTORY/postgresql.conf

tcp_keepalives_count = 0 # TCP_KEEPCNT;

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$

gpadmin=# set tcp_keepalives_count = 20; SET gpadmin=# gpadmin=# gpadmin=#

3) Issue: tcp_keepalives_idle, Default value not sync Doc value to system value, can be set at session, and Reload needed.

Tesing:

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s tcp_keepalives_idle Values on all segments are consistent GUC : tcp_keepalives_idle Master value: 7200 Segment value: 7200 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ grep tcp_keepalives_idle $MASTER_DATA_DIRECTORY/postgresql.conf

tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# show tcp_keepalives_idle gpadmin-# ; tcp_keepalives_idle

0 (1 row)

gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c tcp_keepalives_idle -v 10000 20210727:15:33:41:003032 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c tcp_keepalives_idle -v 10000' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s tcp_keepalives_idle Values on all segments are consistent GUC : tcp_keepalives_idle Master value: 7200 Segment value: 7200 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210727:15:33:52:003122 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210727:15:33:52:003122 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210727:15:33:52:003122 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210727:15:33:52:003122 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210727:15:33:52:003122 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210727:15:33:52:003122 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s tcp_keepalives_idle Values on all segments are consistent GUC : tcp_keepalives_idle Master value: 10000 Segment value: 10000 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# gpadmin=# set tcp_keepalives_idle = 7200; SET gpadmin=# \q [gpadmin@mdw_ipv4 ~]$

4) Issue: tcp_keepalives_interval, Default value not sync Doc value to system value, can be set at session, and Reload needed.

gpadmin=# gpadmin=# set tcp_keepalives_interval = 600; SET gpadmin=# [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s tcp_keepalives_interval Values on all segments are consistent GUC : tcp_keepalives_interval Master value: 75 Segment value: 75 [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ grep tcp_keepalives_interval $MASTER_DATA_DIRECTORY/postgresql.conf

tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.

gpadmin=# show tcp_keepalives_interval; tcp_keepalives_interval

0 (1 row)

[gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c tcp_keepalives_interval -v 60 20210727:15:39:48:003674 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c tcp_keepalives_interval -v 60' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210727:15:39:53:003751 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210727:15:39:53:003751 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210727:15:39:53:003751 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210727:15:39:53:003751 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210727:15:39:53:003751 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210727:15:39:53:003751 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s tcp_keepalives_interval Values on all segments are consistent GUC : tcp_keepalives_interval Master value: 60 Segment value: 60 [gpadmin@mdw_ipv4 ~]$