Encountered a warning message regarding parameter: setting is ignored because it is defunct

Products

• VMware Tanzu Data Suite
• VMware Tanzu Greenplum
• Greenplum

Issue/Introduction

When a parameter has been deprecated the parameter is not removed from the postgresql.conf file. These deprecated parameters can cause WARNING message in Greenplum Database logs. Sometimes it is not enough to turn off the parameter using gpconfig -c 

Resolution

The utility gpconfig has an option to remove the parameter:

-r | --remove param_name
Removes a configuration parameter setting by commenting out the entry in the postgresql.conf files.