Release v22.06.00 adds a new Postgres database user/role for course database access that is not a database superuser.
Before installing this new version, you should specify the username and password for this new database user/role. You do not need to create the user/role for the database, the migration will create the user/role if it does not exist.
As root, edit the file
Add the following lines to the file:
"database_course_user": "submitty_course_dbuser", "database_course_password": "PASSWORD",
PASSWORDwith a secure password. You may optionally specify an alternate username for this database user/role.
Pull the latest code from the repository, and run the installation script:
Note: If you host your database on a separate machine or VM, ensure that the new user/role can connect to the database server. This may involve editing the
pg_hba.conffile, with similar settings for the
See also: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html