As of Jan 2019, we are considering to use Postgresql for teaching. This requires some planning in order to host this product. We have to take into consideration hardware, software requirements, applications available …
The 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