DatabaseUsersCluster < CF

CF Web>Database>PostgreSQL>DatabaseUsersCluster (2013-04-08, DanielAllen) (raw view)

---+ !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=



-- Main.IsaacMorland - 31 Jul 2008

Topic revision: r3 - 2013-04-08 - DanielAllen

Information in this area is meant for use by CSCF staff and is not official documentation, but anybody who is interested is welcome to use it if they find it useful.

Other Webs

My links
- People
- CERAS
- WatForm
- Tetherless lab
- Ubuntu Main.HowTo
- eDocs
- RGG NE notes
- RGG
- CS infrastructure
- Grad images

Edit