CONFIGURE – change a server configuration parameter
CONFIGURE {SESSION | CURRENT DATABASE | SYSTEM}
SET parameter := value ;
CONFIGURE SYSTEM INSERT parameter-class insert-shape ;
CONFIGURE {SESSION | CURRENT DATABASE | SYSTEM} RESET parameter ;
CONFIGURE {CURRENT DATABASE | SYSTEM}
RESET parameter-class [ FILTER filter-expr ] ;This command allows altering the server configuration.
The effects of CONFIGURE SESSION last until the end of the current session. Some configuration parameters cannot be modified by CONFIGURE SESSION and can only be set by CONFIGURE SYSTEM.
CONFIGURE CURRENT DATABASE is used to configure an individual EdgeDB database within a server instance with the changes persisted across server restarts.
CONFIGURE SYSTEM is used to configure the entire EdgeDB instance with the changes persisted across server restarts. This variant acts directly on the file system and cannot be rolled back, so it cannot be used in a transaction block.
The CONFIGURE SYSTEM INSERT variant is used for composite
configuration parameters, such as Auth.
The name of a primitive configuration parameter. Available configuration parameters are described in the Server Configuration section.
The name of a composite configuration value class. Available configuration classes are described in the Server Configuration section.
An expression that returns a value of type std::bool.
Only configuration objects matching this condition will be affected.
Set the listen_addresses parameter:
CONFIGURE SYSTEM SET listen_addresses := {'127.0.0.1', '::1'};Set the query_work_mem parameter for the duration of the session:
CONFIGURE SESSION SET query_work_mem := '4MB';Set the same parameter, but for the current database:
CONFIGURE CURRENT DATABASE SET query_work_mem := '4MB';Remove all Trust authentication methods:
CONFIGURE SYSTEM RESET Auth FILTER Auth.method IS Trust;