Differences

This shows you the differences between two versions of the page.

--- software:postgres:start [2021/01/29 15:10] – seela
+++ software:postgres:start [2021/01/29 15:15] (current) – seela
@@ Line 16: / Line 16: @@
 This will be upon request from the Faculty member.
 \\
 \\
---Group Roles are set up to make access to the database consistent for students, TA's ----and faculty members.
+**Connecting to UserDatabase**
---Users will be added to the groups assigned to the privileges given.
+Once you are logged into to any linux host within EECS at the prompt
-\\
+ $ You can enter:
-\\
+    psql -h db <username>
-To connect to the existing database c3421m
+    Enter password: <your Prof will give you the password>
-use psql -h db username password
 \\
 \\
@@ Line 30: / Line 31: @@
 ====Setup of the Postgres for Teaching====
 \\
-The server software resides on a backend server. Faculty teaching for any semester will request a database be created for teaching. If required a database for each student, once a request is submitted , we will set up the session for the semester.
+The server software resides on a backend server. Faculty teaching for any semester will request to tech@eecs  databases for each student. Once a request is submitted , we will set up the session for the semester.
 Students registered in the course will be given accounts for that semester. At the end of the semester, all students' accounts will be deleted. The accounts will be based on the user accounts on our EECS systems.
 \\
@@ Line 36: / Line 37: @@
 To connect to a database
 From any EECS Linux desktop in the Prism Lab,
-  $ psql -h db
+  $ psql -h db <usernaeme>
+     where -h is the host the database resides on
+            username is the name of your database
+   You will then be asked to enter your password
 \\