ALTER DATABASE

Syntax

ALTER DATABASE database_name
    alter_option;

alter_option depends on the operation you want to perform on the database. For all supported clauses, see the sections below.

Clause

`OWNER TO`

ALTER DATABASE database_name
    OWNER TO new_user;

Parameter or clause	Description
OWNER TO	This clause changes the owner of the database. To alter the owner, you must be able to SET ROLE to the new owning role, and you must have the CREATEDB privilege. Note that superusers have all these privileges automatically.
new_user	The new owner you want to assign to the database.

-- Change the owner of the database named "database1" to user "user1"
ALTER DATABASE database1 OWNER TO user1;

`RENAME TO`

ALTER DATABASE database_name
    RENAME TO new_name;

Parameter or clause	Description
RENAME TO	This clause changes the name of the database. Only the database owner or a superuser can rename a database; non-superuser owners must also have the CREATEDB privilege. The current database cannot be renamed. (Connect to a different database if you need to do that.)
new_name	The new name of the database.

-- Change the name of the database named "database" to "database1"
ALTER DATABASE database RENAME TO database1;

`SET`

ALTER DATABASE database_name SET parameter_name = <value>;

Added in v2.5.0: barrier_interval_ms and checkpoint_frequency

These parameters control barrier/checkpoint timing. By default, RisingWave generates one barrier every 1 second (barrier_interval_ms = 1000) and creates one checkpoint per barrier (checkpoint_frequency = 1). Most users should keep the defaults. See Data persistence.

Parameter or clause	Description
barrier_interval_ms [=] integer clause	Changes how frequently the system injects barriers per-database.
checkpoint_frequency [=] integer clause	Changes how many barriers should pass before triggering a checkpoint per-database.

Alter existing database

ALTER DATABASE travel SET barrier_interval_ms = 2000;
ALTER DATABASE travel SET checkpoint_frequency = 2;

Revert to global default

ALTER DATABASE travel SET barrier_interval_ms = DEFAULT;
ALTER DATABASE travel SET checkpoint_frequency = DEFAULT;

`SET RESOURCE_GROUP`

PREMIUM FEATUREThis is a premium feature. For a comprehensive overview of all premium features and their usage, please see RisingWave premium features.

ALTER DATABASE database_name
    SET RESOURCE_GROUP { TO | = } { DEFAULT | resource_group_name } DEFERRED;

ALTER DATABASE database_name
    RESET RESOURCE_GROUP DEFERRED;

Use this statement to change the resource group metadata for a database. The change does not take effect immediately for inherited streaming jobs. After updating the database resource group, manually trigger recovery for inherited streaming jobs to use the new database resource group.

Parameter or clause	Description
SET RESOURCE_GROUP	Sets the database’s resource group metadata.
RESET RESOURCE_GROUP	Resets the database to the default resource group.
resource_group_name	The target resource group.
DEFERRED	Required. Applies the metadata change without immediately moving inherited streaming jobs.

-- Change the database resource group metadata
ALTER DATABASE travel SET RESOURCE_GROUP = high_priority DEFERRED;

-- Reset the database to the default resource group
ALTER DATABASE travel RESET RESOURCE_GROUP DEFERRED;

ALTER DEFAULT PRIVILEGES ALTER FRAGMENT

⌘I

SQL reference

Python SDK

User-defined functions

Syntax

Clause

`OWNER TO`

`RENAME TO`

`SET`

`SET RESOURCE_GROUP`

​Syntax

​Clause

​OWNER TO

​RENAME TO

​SET

​SET RESOURCE_GROUP

Syntax

Clause

`OWNER TO`

`RENAME TO`

`SET`

`SET RESOURCE_GROUP`