Postgresql is a relational database software that is used for undergraduate teaching - particularly the Databases course.

Postgres is installed on db.socs.uoguelph.ca which is an alias for griphook.socs.uoguelph.ca.

Access to databases is only allowed using Kerberos, so only machines that are set up such as linux.socs or NoMachine are able to access Postgres.

The db-user-import.py script in the sysadmin scripts is used to set up student access. It must be run from one of the linux servers after running the kinit command to get a kerberos ticket.

The script creates a database for each student with the same name as the student username and provides permissions on the database to that student.