Viewing Server Configuration Parameter Settings v6.27.4
This section is adapted from the WarehousePG v6.x documentation
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 coordinator instance only. To see the value of a particular parameter across the entire system (coordinator and all segments), use the gpconfig utility. For example:
$ gpconfig --show max_connections
Parent topic: Configuring the WarehousePG cluster