Issue: - This parameter(IntervalStyle) fails set when given lower case of the parameter, usually All parameter names are case-insensitive (as per Doc page no 1303).
testing:
[gpadmin@mdw_ipv4 ~]$ psql
psql (9.4.24)
Type "help" for help.
gpadmin=#
gpadmin=# show IntervalStyle;
IntervalStyle
postgres
(1 row)
gpadmin=# show intervalstyle;
IntervalStyle
postgres
(1 row)
gpadmin=#
gpadmin=#
gpadmin=# set intervalstyle = 'postgres_verbose';
SET
gpadmin=# \q
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -s intervalstyle
Values on all segments are consistent
GUC : intervalstyle
Master value: postgres
Segment value: postgres
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -c intervalstyle -v postgres_verbose
20210722:13:21:19:025726 gpconfig:mdw_ipv4:gpadmin-[CRITICAL]:-GUC Validation Failed: intervalstyle cannot be changed under normal conditions. Please refer to gpconfig documentation.
GUC Validation Failed: intervalstyle cannot be changed under normal conditions. Please refer to gpconfig documentation.
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -c IntervalStyle -v postgres_verbose
20210722:13:21:35:025787 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c IntervalStyle -v postgres_verbose'
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpstop -u
20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u
20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment...
20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information
20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master...
20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c'
20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$ gpconfig -s intervalstyle
Values on all segments are consistent
GUC : intervalstyle
Master value: postgres_verbose
Segment value: postgres_verbose
[gpadmin@mdw_ipv4 ~]$
[gpadmin@mdw_ipv4 ~]$
Page No : 1358
Issue: - This parameter(IntervalStyle) fails set when given lower case of the parameter, usually All parameter names are case-insensitive (as per Doc page no 1303).
testing:
[gpadmin@mdw_ipv4 ~]$ psql psql (9.4.24) Type "help" for help.
gpadmin=# gpadmin=# show IntervalStyle; IntervalStyle
postgres (1 row)
gpadmin=# show intervalstyle; IntervalStyle
postgres (1 row)
gpadmin=# gpadmin=# gpadmin=# set intervalstyle = 'postgres_verbose'; SET gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s intervalstyle Values on all segments are consistent GUC : intervalstyle Master value: postgres Segment value: postgres [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c intervalstyle -v postgres_verbose 20210722:13:21:19:025726 gpconfig:mdw_ipv4:gpadmin-[CRITICAL]:-GUC Validation Failed: intervalstyle cannot be changed under normal conditions. Please refer to gpconfig documentation. GUC Validation Failed: intervalstyle cannot be changed under normal conditions. Please refer to gpconfig documentation. [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -c IntervalStyle -v postgres_verbose 20210722:13:21:35:025787 gpconfig:mdw_ipv4:gpadmin-[INFO]:-completed successfully with parameters '-c IntervalStyle -v postgres_verbose' [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpstop -u 20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Starting gpstop with args: -u 20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Gathering information and validating the environment... 20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Greenplum Master catalog information 20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Obtaining Segment details from master... 20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Greenplum Version: 'postgres (Greenplum Database) 6.16.0 build commit:5650be2b79197fed564dca8d734d10f2a76b876c' 20210722:13:21:51:025881 gpstop:mdw_ipv4:gpadmin-[INFO]:-Signalling all postmaster processes to reload [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s intervalstyle Values on all segments are consistent GUC : intervalstyle Master value: postgres_verbose Segment value: postgres_verbose [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$