PostgreSQL Users Cluster

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

The purpose is to make available a Postgres installation to CS faculty, staff, and students. So far this is available informally by request. ST#63899 has some information.

Sysadmin support

Access to the apps cluster is via connection to postgres.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://odyssey.uwaterloo.ca/sub - the RSG subscriptions application.

Restarting postgres can be done via: service postgresql restart

-- IsaacMorland - 31 Jul 2008