Setting Parameters at the System Level

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

Edit the $COORDINATOR_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 LightDB-A Database as follows:
```
$ gpstop -r
```

For details about the server configuration parameters, see the LightDB-A Database Reference Guide.

Parent topic: Setting a Coordinator Configuration Parameter