search

vmware-archive / sre-test

Greenplum - Open Source SRE test project.
2 stars 0 forks source link

explain_pretty_print Parameter does not exists in system #181

Closed bala-cg closed 2 years ago

bala-cg commented 3 years ago

Page No: 1327

Issue: explain_pretty_print Parameter is not shown using psql and gpconfig, but present in postgresql.conf file.

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

gpadmin=# show explain_pretty_print; ERROR: unrecognized configuration parameter "explain_pretty_print" gpadmin=# \q [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ gpconfig -s explain_pretty_print 20210716:11:09:44:013515 gpconfig:mdw_ipv4:gpadmin-[ERROR]:-Failed to retrieve GUC information, guc does not exist: explain_pretty_print 'NoneType' object is not iterable [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ [gpadmin@mdw_ipv4 ~]$ grep explain_pretty_print $MASTER_DATA_DIRECTORY/postgresql.conf

explain_pretty_print = on

fifthposition commented 3 years ago

@edespino FYI. Not sure what Docs should do here.