Differences

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

--- software:postgres:start [2019/01/28 09:42] – seela
+++ software:postgres:start [2021/01/29 15:15] (current) – seela
@@ Line 4: / Line 4: @@
 \\
 \\
-Postgres software is set up on a trial basis for Faculty to test.
+Postgres software is set up  for Faculty and Students.
-From any Linux desktop within eecs managed systems, we can use a postgres client application to connect to the database which resides on a backend server.
+From any Linux desktop within EECS managed systems, we can use a postgres client application to connect to the database which resides on a backend server.
 Users accounts will be generated by semester and permissions granted accordingly.
 The connections are restricted to our internal subnets .
+**As of June 2020**, The Technical Team setup a remotely.eecs.yorku.ca server so students can connect to the internal EECS systems with their EECS username and password.
+More information ob how to connect is listed here.
 \\
 \\
 **To test:** You would need a database to connect to and the right access permissions. All accounts created will have a password associated with it.
-For teaching, we will follow the same naming convention as the db2 databases eg: c3421M
+Every student who is registered in EECS3421 will have access to his/her  database based on EECS username.
-The faculty member will be given full dba rights and can add users accordingly
+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 28: / 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.
 \\
+To use Postgres the Teaching faculty must request the class to be created using Postgres. TA names should also be provided. Any special request for authorization should be sent in writing
+To connect to a database
+From any EECS Linux desktop in the Prism Lab,
+  $ 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
 \\