Tanzu Greenplum 5

Viewing Server Configuration Parameter Settings

Last Updated February 12, 2025

The SQL command SHOW allows you to see the current server configuration parameter settings. For example, to see the settings for all parameters:

$ psql -c 'SHOW ALL;'

SHOW lists the settings for the master instance only. To see the value of a particular parameter across the entire system (master and all segments), use the gpconfig utility. For example:

$ gpconfig --show max_connections

Parent topic: Configuring the Greenplum Database System