As of Jan 2019, Faculty teaching the database courses are considering the use Postgresql for teaching. This requires planning on resources and implementation. The technical team have to take into consideration hardware and software requirements and teaching needs.

Postgres software is set up on a trial basis for Faculty to test. From any Linux desktop within eecs managed systems, we can use a postgres client application to connect to the database which resides on a backend server. Users accounts will be generated by semester and permissions granted accordingly. The connections are restricted to our internal subnets .

To test: You would need a database to connect to and the right access permissions. All accounts created will have a password associated with it. For teaching, we will follow the same naming convention as the db2 databases eg: c3421M The faculty member will be given full dba rights and can add users accordingly

Group Roles are set up to make access to the database consistent for students, TA's and faculty members. Users will be added to the groups assigned to the privileges given.

To connect to the existing database c3421m use psql -h db username password

Once connected , you can create tables, queries,set up automated scripting, etc.

The server software resides on a backend server. Faculty teaching for any semester will request a database be created for teaching. If required a database for each student, once a request is submitted , we will set up the session for the semester. Students registered in the course will be given accounts for that semester. At the end of the semester, all students' accounts will be deleted. The accounts will be based on the user accounts on our EECS systems.