Checking Server Configuration Files

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.

Table 1. gp_param_setting('parameter_name') function
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.

Table 2. gp_param_settings_seg_value_diffs view
Column Description
psdname The name of the parameter.
psdvalue The value of the parameter.
psdcount The number of segments that have this value.