software:postgres:start
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
software:postgres:start [2019/01/23 15:41] – 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 | + | Postgres |
- | From any Linux desktop within | + | 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. | **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 |
- | The faculty member | + | This will be upon request from the Faculty member. |
\\ | \\ | ||
+ | |||
\\ | \\ | ||
- | Group Roles are set up to make access | + | **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 < | ||
+ | Enter password: <your Prof will give you the password> | ||
\\ | \\ | ||
\\ | \\ | ||
- | To connect to the existing database c3421m | + | Once connected , you can create tables, queries,set up automated scripting, etc. |
- | use psql -h db username password | + | |
- | \\ | + | |
\\ | \\ | ||
+ | ====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.1548276062.txt.gz · Last modified: 2019/01/23 15:41 by seela