software:postgres:start
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
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. | 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 30: | 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 36: | 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.1611951041.txt.gz · Last modified: 2021/01/29 15:10 by seela