Setting Configuration Parameters

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 5.x documentation.

Setting Configuration Parameters

Many configuration parameters limit who can change them and where or when they can be set.
For example, to change certain parameters, you must be a Greenplum Database superuser. Other
parameters can be set only at the system level in the postgresql.conf
file or require a system restart to take effect.

Many configuration parameters are session parameters. You can set session parameters
at the system level, the database level, the role level or the session level. Database users
can change most session parameters within their session, but some require superuser
permissions.

See the Greenplum Database Reference Guide for
information about setting server configuration parameters.