Setting a Local Configuration Parameter

This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.

Setting a Local Configuration Parameter

To change a local configuration parameter across multiple segments, update the parameter in the postgresql.conf file of each targeted segment, both primary and mirror. Use the gpconfig utility to set a parameter in all Greenplum postgresql.conf files. For example:

$ gpconfig -c gp_vmem_protect_limit -v 4096

Restart Greenplum Database to make the configuration changes effective:

$ gpstop -r