Coordinator parameter settings in the coordinator postgresql.conffile are the system-wide default. To set a coordinator parameter:

  1. Edit the $COORDINATOR_DATA_DIRECTORY/postgresql.conf file.

  2. Find the parameter to set, uncomment it (remove the preceding # character), and type the desired value.

  3. Save and close the file.

  4. For session parameters that do not require a server restart, upload the postgresql.conf changes as follows:

    $ gpstop -u
    
  5. 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.

Parent topic: Setting a Coordinator Configuration Parameter

check-circle-line exclamation-circle-line close-line
Scroll to top icon