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

Topic revision: r3 - 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