CONFIGURE – change a server configuration parameter

CONFIGURE {SESSION | CURRENT DATABASE | INSTANCE}
    SET parameter := value ;
CONFIGURE INSTANCE INSERT parameter-class insert-shape ;
CONFIGURE {SESSION | CURRENT DATABASE | INSTANCE} RESET parameter ;
CONFIGURE {CURRENT DATABASE | INSTANCE}
    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 INSTANCE.

CONFIGURE CURRENT DATABASE is used to configure an individual EdgeDB database within a server instance with the changes persisted across server restarts.

CONFIGURE INSTANCE 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 INSTANCE INSERT variant is used for composite configuration parameters, such as Auth.

parameter

The name of a primitive configuration parameter. Available configuration parameters are described in the Config section.

parameter-class

The name of a composite configuration value class. Available configuration classes are described in the Config section.

filter-expr

An expression that returns a value of type std::bool. Only configuration objects matching this condition will be affected.

Set the listen_addresses parameter:

Copy
CONFIGURE INSTANCE SET listen_addresses := {'127.0.0.1', '::1'};

Set the query_work_mem parameter for the duration of the session:

Copy
CONFIGURE SESSION SET query_work_mem := <cfg::memory>'4MiB';

Set the same parameter, but for the current database:

Copy
CONFIGURE CURRENT DATABASE SET query_work_mem := <cfg::memory>'4MiB';

Add a Trust authentication method for “my_user”:

Copy
CONFIGURE INSTANCE INSERT Auth {
    priority := 1,
    method := (INSERT Trust),
    user := 'my_user'
};

Remove all Trust authentication methods:

Copy
CONFIGURE INSTANCE RESET Auth FILTER Auth.method IS Trust;
Light
Dark
System