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/31 15:36] – 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 | + | Postgres software is set up for Faculty |
- | 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 to the database consistent for students, TA's and faculty members. | + | **Connecting |
- | 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==== | ====Setup of the Postgres for Teaching==== | ||
\\ | \\ | ||
- | The server software resides on a backend server. Faculty teaching for any semester will request | + | The server software resides on a backend server. Faculty teaching for any semester will request |
Students registered in the course will be given accounts for that semester. At the end of the semester, all students' | Students registered in the course will be given accounts for that semester. At the end of the semester, all students' | ||
\\ | \\ | ||
Line 34: | Line 37: | ||
To connect to a database | To connect to a database | ||
From any EECS Linux desktop in the Prism Lab, | From any EECS Linux desktop in the Prism Lab, | ||
- | $ psql -h db | + | $ 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.1548967011.txt.gz · Last modified: 2019/01/31 15:36 by seela