ALTER GLOBAL CONFIGURATION

Description

Adds or modifies key-value of the gs_global_config system catalog. You can modify an existing parameter or add a new one.

Precautions

Only the initial database user can run this command.
The parameter name cannot be weak_password or undostoragetype.

Syntax

ALTER GLOBAL CONFIGURATION with(name=value, name=value...);

Parameters

name
Parameter name, which is of the text type. The value cannot be weak_password or undostoragetype.

value
Parameter value, which is of the text type.

Examples

    
     
       
       
         -- Insert.
gaussdb=# ALTER GLOBAL CONFIGURATION with(redis_is_ok = true);

-- Query.
gaussdb=# SELECT * FROM gs_global_config;
      name       | value
-----------------+-------
 buckets_len     | 16384
 undostoragetype | page
 redis_is_ok     | true
(3 rows)

-- Modify.
gaussdb=# ALTER GLOBAL CONFIGURATION with(redis_is_ok = false);

-- Query.
gaussdb=# SELECT * FROM gs_global_config;
      name       | value
-----------------+-------
 buckets_len     | 16384
 undostoragetype | page
 redis_is_ok     | false
(3 rows)

-- Delete.
ggaussdb=# DROP GLOBAL CONFIGURATION redis_is_ok;

-- Query.
gaussdb=# SELECT * FROM gs_global_config;
      name       | value
-----------------+-------
 buckets_len     | 16384
 undostoragetype | page
(2 rows)

        

      

    
   