Postgres Personal Databases

To set up personal databases on postgres.student.cs or postgres.cs, log in to linux.student.cs (tested) or linux.cs (actually, broken; use mx100.cs instead; actually database credentials for user DB script not fully set up, so won't work anyhow yet) as appropriate, and run as root /software/odyssey-3/private/userdb-setup.

To set up specific users, give --user followed by some userids as separate parameters.

To set up an entire class, give --offering-admin-id and an Instruct admin_id. Every current student, instructor, and TA in the current term will be set up. To identify the correct admin_id, use https://odyssey.uwaterloo.ca/teaching/admin/. Click through to the correct course, verify it is offered with the correct instructors in the relevant term, and note the admin_id in the URL.

When a user is set up, a login role, database, and schema are created for them, all named the same as their WatIAM userid.

The password is saved in ~/.pgpass so that the user should be able to type psql -h postgres.student.cs or psql -h postgres.cs as appropriate to connect to their database. If there is already a ~/.pgpass then ~/new.pgpass.1, ~/new.pgpass.2, are used. In this case the saved password entry will have to be moved to ~/.pgpass to be effective. The schema is created in the postgres database.

-- IsaacMorland - 2015-05-22

Topic revision: r2 - 2015-05-29 - IsaacMorland
 
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