Setting a Local Configuration Parameter v7.4
This section is adapted from the WarehousePG v7.x documentation
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 WarehousePG postgresql.conf files. For example:
$ gpconfig -c gp_vmem_protect_limit -v 4096
Restart WarehousePG to make the configuration changes effective:
$ gpstop -r
Parent topic: Setting Configuration Parameters