Administering an instance

Create a database:

1. db>

1. create database my_new_project;

1. OK: CREATE DATABASE

Create a role:

1. db>

1. create superuser role project;

1. OK: CREATE ROLE

Configure passwordless access (such as to a local development database):

1. db>
2. ...
3. ...
4. ...
5. ...
6. ...
7. ...
8. ...

1. configure instance insert Auth {
2. # Human-oriented comment helps figuring out
3. # what authentication methods have been setup
4. # and makes it easier to identify them.
5. comment := 'passwordless access',
6. priority := 1,
7. method := (insert Trust),
8. };

1. OK: CONFIGURE INSTANCE

Set a password for a role:

1. db>
2. ...

1. alter role project
2. set password := 'super-password';

1. OK: ALTER ROLE

Configure access that checks password (with a higher priority):

1. db>
2. ...
3. ...
4. ...
5. ...

1. configure instance insert Auth {
2. comment := 'password is required',
3. priority := 0,
4. method := (insert SCRAM),
5. };

1. OK: CONFIGURE INSTANCE

Remove a specific authentication method:

1. db>
2. ...

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

1. OK: CONFIGURE INSTANCE

Run a script from command line:

1. cat myscript.edgeql | edgedb [connection-option...]