PostgreSQL Users Cluster

This cluster is available via the default port on

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 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 - the RSG subscriptions application.

Restarting postgres can be done via: service postgresql restart

-- IsaacMorland - 31 Jul 2008

Edit | Attach | Watch | Print version | History: r3 < r2 < r1 | Backlinks | Raw View | WYSIWYG | More topic actions
Topic revision: r3 - 2013-04-08 - DanielAllen
This site is powered by the TWiki collaboration platform Powered by PerlCopyright © 2008-2023 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback