software:postgres:start
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
software:postgres:start [2019/01/22 15:27] – created seela | software:postgres:start [2021/01/29 15:15] (current) – seela | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== Instructions for Accessing Postgres within EECS ====== | ====== Instructions for Accessing Postgres within EECS ====== | ||
\\ | \\ | ||
- | As of Jan 2019, we are considering | + | As of Jan 2019, Faculty teaching the database courses |
\\ | \\ | ||
- | The software is set up on a trial basis for Faculty | + | \\ |
- | From any Linux desktop within | + | Postgres |
+ | From any Linux desktop within | ||
Users accounts will be generated by semester and permissions granted accordingly. | Users accounts will be generated by semester and permissions granted accordingly. | ||
The connections are restricted to our internal subnets . | 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 | ||
- | The faculty member will be given full dba rights and can add users accordingly | ||
\\ | \\ | ||
- | Group Roles are set up to make access | + | **To test:** You would need a database |
- | Users will be added to the groups assigned to the privileges given. | + | Every student who is registered in EECS3421 will have access to his/ |
+ | This will be upon request from the Faculty member. | ||
\\ | \\ | ||
- | To connect to the existing database c3421m | ||
- | use psql -h db username password | ||
- | |||
+ | \\ | ||
+ | **Connecting to UserDatabase** | ||
+ | Once you are logged into to any linux host within EECS at the prompt | ||
+ | $ You can enter: | ||
+ | psql -h db < | ||
+ | Enter password: <your Prof will give you the password> | ||
+ | |||
+ | \\ | ||
+ | \\ | ||
+ | Once connected , you can create tables, queries,set up automated scripting, etc. | ||
+ | \\ | ||
+ | |||
+ | ====Setup of the Postgres for Teaching==== | ||
+ | \\ | ||
+ | The server software resides on a backend server. Faculty teaching for any semester will request to tech@eecs | ||
+ | Students registered in the course will be given accounts for that semester. At the end of the semester, all students' | ||
+ | \\ | ||
+ | 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 < | ||
+ | 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 | ||
+ | |||
+ | |||
+ | \\ |
software/postgres/start.1548188829.txt.gz · Last modified: 2019/01/22 15:27 by seela