The purpose is to make available a Postgres installation for instructional purposes.

See ST#84316 for some detail on setup and usage.

Applications currently include Marmoset and CS100 Mediawiki.

Sysadmin support

Access to the apps cluster is via connection to postgres.student.cs.uwaterloo.ca port 5432.

Admin access can be gained by becoming user postgres on that server; psql -p 5432 will access the database without a password.

A manual backup can be performed via: pg_dumpall -p 5432 > dump.sql

A quick test of whether the database is working can be performed by accessing https://www.student.cs.uwaterloo.ca/~cs100/wiki/Main_Page - authentication will fail for someone not involved with the course, but the page-load requires database queries.

Restarting postgres can be done via: service postgresql restart

-- DanielAllen - 08 Apr 2013