Setting Parameters at the System Level
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
Setting Parameters at the System Level
Master parameter settings in the master postgresql.conf file are the system-wide default. To set a master parameter:
- Edit the $MASTER_DATA_DIRECTORY/postgresql.conf file.
- Find the parameter to set, uncomment it (remove the preceding # character), and type the desired value.
- Save and close the file.
- For session parameters that do not require a server restart,
upload the postgresql.conf changes as follows:
$ gpstop -u
- For parameter changes that require a server restart, restart Greenplum
Database as follows:
$ gpstop -r
For details about the server configuration parameters, see the Greenplum Database Reference Guide.