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.

1. As root, edit the file /usr/local/submitty/config/database.json

   Add the following lines to the file:

   "database_course_user": "submitty_course_dbuser",
   "database_course_password": "PASSWORD",
   

   Replacing PASSWORD with a secure password. You may optionally specify an alternate username for this database user/role.

2. Pull the latest code from the repository, and run the installation script:

   sudo /usr/local/submitty/.setup/INSTALL_SUBMITTY.sh
   

3. 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.conf file, with similar settings for the submitty_dbuser and submitty_course_dbuser roles.

   See also: https://www.postgresql.org/docs/current/auth-pg-hba-conf.html