Checking Server Configuration Files
A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
Checking Server Configuration Files
Each component of a Greenplum Database system (master, standby master, primary segments, and mirror segments) has its own server configuration file (postgresql.conf). The following gp_toolkit objects can be used to check parameter settings across all primary postgresql.conf files in the system:
gp_param_setting('parameter_name')
This function takes the name of a server configuration parameter and returns the postgresql.conf value for the master and each active segment. This function is accessible to all users.
Column | Description |
---|---|
paramsegment | The segment content id (only active segments are shown). The master content id is always -1. |
paramname | The name of the parameter. |
paramvalue | The value of the parameter. |
Example:
SELECT * FROM gp_param_setting('max_connections');
gp_param_settings_seg_value_diffs
Server configuration parameters that are classified as local parameters (meaning each segment gets the parameter value from its own postgresql.conf file), should be set identically on all segments. This view shows local parameter settings that are inconsistent. Parameters that are supposed to have different values (such as port) are not included. This view is accessible to all users.
Column | Description |
---|---|
psdname | The name of the parameter. |
psdvalue | The value of the parameter. |
psdcount | The number of segments that have this value. |