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 LightDB-A 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 LightDB-A Database Reference Guide for information about setting server configuration parameters.

• Setting a Local Configuration Parameter

• Setting a Coordinator Configuration Parameter

Parent topic: Configuring the LightDB-A Database System