This is an old revision of the document!
Table of Contents
Database Access (Undergrad)
A Postgres database is available for EECS courses requiring database use. Faculty who want to use the database in their course can send a request to tech including the respective course and section numbers. The tech team will create a database for each student in each course.
Access Database By CLI
In order to access the database by command line, students can issue the “psql” command from any EECS tech-supported Linux system. Students must be enrolled in a course that has requested database access. The student will be logged into Postgres, and connected to a database that has the same name as their EECS username.
Access Database By GUI
An enterprise database management tool called DBeaver Enterprise is available for students to access the database in a GUI. Students will need to complete the steps below one time:
- From the Linux terminal, type “id -u”. You will get back a number. Record that number.
- Start DBeaver with the “dbeaver” command.
- When DBeaver starts, you will be prompted: “Do you want to create sample database? It can be used as an example to explore basic DBeaver Enterprise features”. You can select Yes/No.
- From the “File” menu, choose “New”, then open “DBeaver” folder, then select “Database Connection”.
- Click Next >
- Select “PostgresSQL” from the list of available databases.
- Click Next >
- In the “Connect to a database” window, change:
- Hostname: db.eecs.yorku.ca
- Database: <your EECS username>
- Authentication: change to “PostgreSQL Kerberos”
- Username: <your EECS username>
- Kerberos user: leave default value
- Realm: leave default value
- KDC server: leave default value
- Password: <enter your EECS password>
- Next, click on “Extra Configuration” which opens up a few options.
- Check off: “Use kinit” and replace the contents of the text field with: /tmp/krb5cc_<uid> where <uid> is the number you recorded in the first step.
- Click “Finish”.
- Under “Database Navigator” tab, you will now see: “<your EECS-username> - db.eecs.yorku.ca:5432”
- Click on the down arrow, and you will be connected to your personal database.