This cluster is available via the default port on postgres.student.cs.uwaterloo.ca.

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

Topic revision: r1 - 2013-04-08 - DanielAllen
 
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2019 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback