Administering an instance​

db> 

create database my_new_project;

db> 

create superuser role project;

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

configure instance 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 instance insert Auth {
    comment := 'password is required',
    priority := 0,
    method := (insert SCRAM),
};

db> 
... 

configure instance reset Auth
filter .comment = 'password is required';