Retrieve Default and Current gpconfig Parameters in Greenplum

Products

• VMware Tanzu Greenplum
• VMware Tanzu Greenplum / Gemfire
• VMware Tanzu Data Suite
• VMware Tanzu Data Suite

Issue/Introduction

In Greenplum, administrators may need a programmatic method to retrieve all configuration parameters along with both their current values and default values for validation, auditing, or health check purposes.

Although the "gpconfig -l" command lists configuration parameters, it does not provide a way to compare the currently active value with the default value in a structured format suitable for automation or reporting.

Resolution

To retrieve all configuration parameters along with their current and default values, execute the following SQL query against the Greenplum database:

SELECT name,
       setting AS current_value,
       boot_val AS default_value,
       unit,
       short_desc
FROM pg_settings
ORDER BY name;

Here -

setting → shows the currently active value 

boot_val → shows the compiled default value

pg_settings → contains ALL configuration parameters visible to gpconfig