Admin Commands

db> 

CREATE DATABASE my_new_project;

db> 

CREATE SUPERUSER ROLE project;

db> 
... 
... 
... 
... 
... 
... 
... 

CONFIGURE SYSTEM INSERT Auth {
    # Human-oriented comment helps figuring out
    # what authentication methods have been setup
    # and makes it easier to identify them.
    comment := 'passwordless access',
    priority := 1,
    method := (INSERT Trust),
};

db> 
... 

ALTER ROLE project
    SET password := 'super-password';

db> 
... 
... 
... 
... 

CONFIGURE SYSTEM INSERT Auth {
    comment := 'password is required',
    priority := 0,
    method := (INSERT SCRAM),
};

db> 
... 

CONFIGURE SYSTEM RESET Auth
FILTER .comment = 'password is required';